Thursday, March 22, 2012

Connecting to reporting services

I am trying to connect to my reporting services. I keep getting the following error. I am in the sysadmin role What else do I need access to in order to connect?
TIA,
Joe
TITLE: Connect to Server

Cannot connect to ENSQLD1\ENSQLD1_2005.


ADDITIONAL INFORMATION:

The request failed with HTTP status 401: Access Denied. (Microsoft.SqlServer.Management.UI.RSClient)


BUTTONS:

OK

Are you a local system admin to the Report Server? If not then a local admin will have to grant you rights to the Report server. The Database roles have no meaning to the Report Server service.

-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.sqlsql

No comments:

Post a Comment