December 15, 2011 at 11:40 am
Hi,
I have installed & configured SQL Server 2008 R2 on Server A The reporting services runs under the account abc\mssqlsrv.
The reportserver & reportserverTempdb are configured to store on Server B with SQL Server 2008 R2, which is aslo running under the account abc\mssqlsrv
Everything is green in Reporting services configuration manager
But getting below error when I open reportserver url http://servername/reportserver
The permissions granted to user ABC\mssqlsrv' are insufficient for performing this operation. (rsAccessDenied) Get Online Help
Then I tried with the account abc\admin (sysadmin) to login to the http://servername/reportserver) and getting the below error
The permissions granted to user ABC\admin are insufficient for performing this operation. (rsAccessDenied) Get Online Help
Verified that rsexecrole and db_owner permissions are already exist for ABC\mssqlsrv in reportserver database
and ABC\admin is an admin account with all permissions
Please advice
December 15, 2011 at 11:46 am
Can you screenshot your configuration so we can see how you have things configured?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 15, 2011 at 11:55 am
It is probably because the user has not yet been added to a server group outside of SQL. Try logging in as sa and then managing the users through the reporting services interface.
Jared
Jared
CE - Microsoft
December 15, 2011 at 12:02 pm
Also, is abc\admin a server administrator? Not SQL Server, but local or domain.
Jared
Jared
CE - Microsoft
December 15, 2011 at 12:06 pm
Inside the server, It's working when I open the Internet explorer Run As Administrator:-):-)
Out side the server, it just works fine...thanks
December 16, 2011 at 7:48 am
Ah, the UAC. That makes a bit of sense.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply