reportserver error connecting database
hi all,
getting error while access reportserver (http://localhost/reportserver)
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) (Report Services SOAP Proxy Source)
when i try to access reporting service through management studio,i got this error
Cannot open database "ReportServer" requested by the login. The login failed.
Login failed for user 'xxxxx\Administrator'. () (.Net SqlClient Data Provider)
i tried various possibilities like
1. rsconfig -c -sxxxx -dxxxx -aWindows -xxxx\administrator -pxxxx
2. given full permissions to users and anonymous access\guests....
3. report service utility i even set user amin for execute account tab
also i ggogled nothing worked,
the funny thing is that im logged in as administrator and how can reporting services connecting to database needs security access??
need your reviews plz.
Thanks & Regards Vijender Reddy
February 18th, 2011 9:02pm