Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Renamed ReportServer DB causing UAE issues

Author  Topic 

dmumper
Starting Member

1 Post

Posted - 2011-05-26 : 15:09:14
Greetings.

As part of our transition from one SSRS 2005 server to another, the ReportServer database that was installed by default was renamed to ReportServer2005. Ever since we did that, our unattended execution login keeps causing login errors.

Cannot open database "ReportServer" requested by the login. The login failed.
Error: 18456, Severity: 14, State: 16.

The report renders just fine, but none of the images are displayed. So it seems like the report service is finding the new database name just fine, but the UAE isn't.

Has anybody seen something like this or can point me in a direction to look?

Thanks.

Dale.
   

- Advertisement -