May 20, 2009 at 3:12 pm
Reporting Services in Server A is running under local system
In database connection, Report database is created in Server B with SQL Server credentials Sa.
Now when I browse the Report Server, it says
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help
Login failed for user 'sa'.
Please advice....
May 20, 2009 at 5:31 pm
Could you please give some info. Because the application not bringing the reports from report server and its giving report server can not be connected???
May 20, 2009 at 5:55 pm
You need to create a domain account and use it to run SSRS so you can add that account in Server B on the Windows level, SQL Server login, ReportServerDB user, ReportServerTempDB user and the database used for your datasource as user. Now your application is running as SA in one box while the other Server does not know SSRS in the other Server. This is very time consuming work even in one box I did yesterday correct one error then another but all is fixed now so go back and create domain admin account to Admin SSRS.
Kind regards,
Gift Peddie
May 20, 2009 at 9:14 pm
The catch here is...the 2 servers are not in domain. So No AD accounts and I can not create domain accounts.
Server A has Reporting services installed and in server B Report server n ReportServerTemb get created 2 years ago. I checked Reporting Services Configuration manager in ServerA:
In Database setup: Server B\Ins1
ReportServer n ReportServerTempdb were created using
SQL Server Credentilas
Sa
password
Now, I went to server B and changed the Sa password to xxxxxx(because nobody knows the Sa password in Server B).
Then I went to Server A and browse http://server A/reports:
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help
Login failed for user 'sa'[10.10.10.10].
Iam getting above error Login failed for user 'sa' continuosly in Event viewer and in error log of Server B after changing the Sa password in Server B.
Before changing Sa password in Server B, I did not have this error Login failed for user 'sa'[10.10.10.10](this is the IP of Sevrer A)
and one more thing The Initialization is greyed out and read in BOL that for Standard edition of SQL server 2005, its normal to have Initialization greyed out. Is that true?
Please help me out...much pressure coming from management to get make it work by today....
any inputs will be appreciated
May 20, 2009 at 11:02 pm
Have You done the hosts file entry in both servers for each other.
Thanks
May 20, 2009 at 11:06 pm
I am not sure but if the servers will be add as a linked server then it could be possible.
Thanks
May 21, 2009 at 12:18 pm
All that is not needed AD or Domain is not relevant either if it was working then you need to go back and find all the places that account is used and make changes like reopening connection properties and making sure you code runs.
Kind regards,
Gift Peddie
May 21, 2009 at 12:52 pm
I did not understand why Iam getting the error
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help
Login failed for user 'sa'[10.10.10.10].
All the items in ReportServer configuration toll are green, and created the report server n report serverTempDb in server B using Sa, and they were created succesfully. But when I entered http://servername/reportserver, iamgetting this error
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help
Login failed for user 'sa'[10.10.10.10].
Please help me
May 21, 2009 at 1:37 pm
Have You done the hosts file entry in both servers for each other
I stand corrected the above is relevant to your problems so go to the location below in your drive where SQL Server is installed and run the SSRS utilities it is explained in the two links below.
C:\Program Files\Microsoft SQL Server\90\Tools\Binn
http://msdevelopers.blogspot.com/2005/03/rsreportserverdatabaseunavailable-on.html
http://msdn.microsoft.com/en-us/library/aa179654.aspx
Kind regards,
Gift Peddie
May 21, 2009 at 3:52 pm
rsconfig -c -s -dreportserver -aSQL -u -p
In above, for My case
rsconfig -c -sserverB -dreportserver -aSQL -uSa -pxxxxxxx is that right??? and this should be run from Server A(which is Re porting Server) and ServerB is the has the reportserver n ReportServerTempDB.
or Can I create a login called 'Adminin' ServerB with sysadmin rights and use that user name in rsconfig -c -s -dreportserver -aSQL -u -p by replacing username with Admin. I sthat makes sense and is going to work???
please clarify me.
May 21, 2009 at 4:07 pm
I like to fix problems by trying the easy one so go to the location below and add your IP address into the host file of the new server, it is there I found mine in less than one minute. If that does not work then we can go to the long path which is permissions adding.
I forgot to add open the host file with notepad and add your server IP address and save it.
C:\WINDOWS\system32\drivers\etc
Kind regards,
Gift Peddie
May 21, 2009 at 4:33 pm
We 2 servers Server A (For RS) and Server B (For storing ReportServer n ReportTempDb). So in which server Do I need to look for the IP in the path C:\WINDOWS\system32\drivers\etc
1. Go to Sevrer A and add the IP of ServerB in the path C:\WINDOWS\system32\drivers\etc OR
2.Go to Server B and add the IP of Server A in the path C:\WINDOWS\system32\drivers\etc OR
3.Go to Server A and add Server A's IP in C:\WINDOWS\system32\drivers\etc OR
4.Go to Server B and add Server B's IP in C:\WINDOWS\system32\drivers\etc OR
Many thanks
May 21, 2009 at 4:47 pm
You are not in a Domain so try adding A IP address in B and B IP address in A and if you are still getting errors post again and I will work out the permissions chain for you.
Kind regards,
Gift Peddie
May 22, 2009 at 12:46 am
I added the IP addresses in host file in both servers as you suggested. Still when I browse the Reportserver, Iam getting the same error
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help
Login failed for user 'sa'
and when I browse Reports, Iam getting the below error:
The request failed with HTTP status 400: Bad Request
what will be the next steps I can take to fix this error and to make work the reports
thanks
May 22, 2009 at 12:54 am
Have u checked your IIS settings...
Thanks
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply