TIP: Moving Reporting Servers between domains

  • Article

 

I recently had to move some development SRS machines from one domain to another at work. This consisted of two cluster web boxes, and one SQL Server, using SQL auth.

 

After doing so, I received the following error:

 

Reporting Services 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 '<domainname>\<servername>$'.

 

The fix for this (thanks to the SRS team!) is as follows:

 

  • Create a new SQL login for the new machine account.
  • Add the new SQL account to the RSExec role in the following DBs:
    • ReportServer
    • ReportServerTempDB
    • msdb
    • master

Of course, if you set up your SQL box to use non-standard DB names, replace ReportServer and ReportServerTempDB with the names you have used.

 

I hope that someone out there finds this useful.

 

cheers,

~stuart