Reporting services is not working???

  • 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....

  • 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???

  • 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

  • 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

  • Have You done the hosts file entry in both servers for each other.

    Thanks

  • I am not sure but if the servers will be add as a linked server then it could be possible.

    Thanks

  • 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

  • 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

  • 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

  • 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.

  • 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

  • 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

  • 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

  • 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

  • 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