How Can I Deploy My Database In Ssrs

Question

1.00/5 (1 vote)

See more:

SSRS-2008

I need to Deploy my database but problem is that it shows invalid path and i need to deploy my database without been asked for a reporting server database

Posted 11-Jul-15 20:52pm

Member 10418330

Add a Solution

Comments

Wendelius 12-Jul-15 3:04am

Do you deploy a database to an existing SQL Server or are you deploying the SQL Server? Also what is the deployment mechanism you use?

Member 10418330 12-Jul-15 3:26am

i am trying to deploy the existing database and on debugging in visual studio 2008 data is displayed but i am not able to deploy as i am new to ssrs so kindly guide me.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Accepted Answer · 2015-07-11T21:57:00

Solution 1

If I understand your question correctly, you can utilize configuration file with your SQL Server installation. Have a look at Install SQL Server 2012 Using a Configuration File[^].

The easiest way to create a configuration file is to run the setup for SQL Server and in the end of the wizard, save the selections into a file. After this you can modify the configuration file as you like.

For different options you can control, have a look at Install SQL Server 2012 from the Command Prompt[^]. For example you can select the installation mode for SSRS by using /RSINSTALLMODE

Posted 11-Jul-15 21:57pm

Wendelius

Comments

Member 10418330 12-Jul-15 4:48am

ok thankx. but on deploying report some authentication is required and i tried every user name and password but failed so kindly provide an solution

Wendelius 12-Jul-15 5:44am

If SQL Server authentication is used, then the password and the user name are defined during the installation, so I'm not able to say what they are.

However if you can use Windows authentication then you don't need to provide username nor password. Have a look at https://www.connectionstrings.com/sqlconnection/trusted-connection/[^]