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.
| Author |
Topic |
|
learntsql
524 Posts |
 Posted - 2010-02-18 : 00:25:29
|
| Hi..I have taken a backup of my report server database of my production and i restored in my laptop.But while opening reporting services its giving an error as "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 HelpCannot open database "ReportServer" requested by the login. The login failed. Login failed for user 'MyLapTop\ASPNET'. "please help me its urgent.TIA. |
|
|
Husband
Starting Member
6 Posts |
Posted - 2010-03-01 : 09:20:35
|
| Hello,I would think that the Execution Account that you have specified within the Reporting Services Configuration manager is MyLapTop\ASPNET.You'll want to ensure that this user has access to the ReportServer database within SQL Management Studio. If that doesnt do it, then you will have to add that user to the permissions at http://localhost/ReportsHope this helps, |
 |
|
|
|
|
|
Error While Opening ReportServer Database