dotnetpro
asked on
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing
Experts,
Any idea about the error i am getting after installing SQL reporting services 2005 ? The user that is trying to access the database is machinename\ASPNET. User has dbowner rights on the ReportServer$SQLExpress.I also have TCP/IP and Named Pipes protocol for SQLExpress enabled. Any thing else that i should be doing ?
reportingserverissue.bmp
Any idea about the error i am getting after installing SQL reporting services 2005 ? The user that is trying to access the database is machinename\ASPNET. User has dbowner rights on the ReportServer$SQLExpress.I also have TCP/IP and Named Pipes protocol for SQLExpress enabled. Any thing else that i should be doing ?
reportingserverissue.bmp
ASKER
Yes the connections were enabled but for some reason it was still giving me issues. I reinstalled SQL express . It took three installs to get this problem fixed.
But it's fixed now?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SqlRemoteConnection.GIF