Authentication errors
This is SQL Server 2008 R2
Recently I configured reporting services to use Kerberos. After creating the SPN's, changing the service account to the domain account for the SPN and updating the RSreportserver config file to use the following authentication types
<AuthenticationTypes>
<RSWindowsNegotiate/>
<RSWindowsKerberos />
<RSWindowsNTLM />
</AuthenticationTypes>
I am getting the following error "User 'Domain\fkearney' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed". If I launch Internet Explorer
as an Administrator, I can get into Report Manager and I can see that my domain account is a System Administrator.
Any thoughts?Frank
May 5th, 2011 1:48pm
Hi Frank,
According to the error message, the problem could be caused by UAC (User Account Control). Before everything, I would suggest you try the suggestion (answer) mentioned in the following thread and article,
Does not have required permissions:
http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/9b5a8763-84ce-46d0-b011-067ad39223d1/
SSRS and UAC (User Access Control):
http://skamie.wordpress.com/2010/06/24/ssrs-and-uac/
The quick fix is to disable the UAC. If you don't want to do that then just do the below:
1. Launch IE using "Run As Administrator" and in SSRS (http://servername/Reports) click on Site Settings. In Site Settings navigate to "Security" and add your user "Domain\fkearney" as a System Administrator.
2. Click on "Home" and then "Folder Settings". Now add your account again this time assigning yourself all the roles (Browser, Content Manager, My Reports, Publisher, Report Builder).
3. Close Administrative IE session and open a normal IE window and verify if we are able to open the Report Manager again.
If any question, please feel free to ask.
Thanks,
Eileen.
Free Windows Admin Tool Kit Click here and download it now
May 9th, 2011 11:29am