Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Insufficient permissions to connect to SSRS Report server

Status
Not open for further replies.
Jun 21, 2015
1
GB
I have an error when accessing the SSRS report server. I have a User account that allows me to run as administrator and it connects fine, but when I connect as the user itself, I get the User has insufficient permissions. I have seen many forums items but have yet to find a solution. I have set the User as system administrator but it will not allow me to connect.

If I cannot connect with this account then I am not likely to be able to get other standard Users to connect.

I am using SQL Server Management Studio Express so I cannot create a new system User as one forum suggested. I also haven't had to do this at other sites. I have set the Browser rights to the Everyone User, which has worked fine on other sites.

Can anyone suggest any solutions to this? or provide a T-SQL means to create a system user with reporting services permission roles?

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top