After
successfully installing report services and configuring all options in ‘Reporting
Services Configuration Manager’ while trying to access the URL under ‘Reporting
Manager URL’ section of configuration manager its asking to provide credentials
which is weird as it should directly connect. To avoid this we need to add the
respective reporting URL to ‘Trusted Site’ zone in iexplorer Tools - >
Internet Options -> Security -> Trusted Sites -> Sites.
Now
after adding the reporting URL to trusted sites zone it’s not asking for
credentials but after connecting throwing below error:
User
'' does not have required permissions. Verify that sufficient permissions have
been granted and Windows User Account Control (UAC) restrictions have been
addressed.
This
happens when the user does not have the permission to the reporting url, even
if you have windows admin privileges, access to reports URL should be given explicitly.
This happens mostly during fresh installations, in such case you need to open
iexplorer or browser with administrator credentials like shown in screenshot
below:
Right
click on iexplorer and select the option ‘Run as administrator’, once browser
will open, open the report url and in url on right hand top corner you will
find option ‘ Site Settings’ shown in screen shot below
Click
on Site Settings and in it click on ‘Security’ tab
Under
security tab click on ‘New Role Assignment’ and add the user to whom you want
to give the access to SSRS URL and click on OK. In our case you can add the
user with which you logged into machine and give him ‘System Administrator’ and
‘System User’ roles. After giving permission you should not receive this error
any more.
Thanks!!
