paulck2007
MIS
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
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