Post reply

SSRS - Access permission denied (URL)

  • April 20, 2011 at 3:23 am

    #238101

    Hi,

    First time successfully create one sample report project by using SQL BI Development Studio.

    I am using my Network Service account for SSRS configuration on server side, and created one sample project, it is working fine.

    URL - ipaddress/reportserver access denied due domain\account permission.

    after that domain\account added to local Administrators group then only can able to access URL. The same domain\account already assigned to sysadmin permission in SSMS.

    Please tell me, Is it mandatory to assign local Administrators group for domain\account?

    Thanks

    ananda

  • April 20, 2011 at 7:08 am

    #1313910

    Hi,

    Please see if the following link answers your question

    http://forums.asp.net/t/1328158.aspx/1?SQL+Server+2008+Reporting+Services+Permissions+Help

  • April 22, 2011 at 2:38 am

    #1314807

    tdmech56 (4/20/2011)

    Hi,

    Please see if the following link answers your question

    http://forums.asp.net/t/1328158.aspx/1?SQL+Server+2008+Reporting+Services+Permissions+Help%5B/quote%5D

    1. “SQLServer2008ReportingServiceWebServiceUser$MachineName$InstanceName” -Local User group not available

    2. “SQL2008ReportServerUser$MachineName$InstanceName” - this is available in Local user group. (here I added domain account after that URL not able to access)

    Timely resolved issue ,domain user just added into Administrators Group then URL can accessed. suppose 10 domain user can able to access URL, I cannot add the Administrators Group.

    currently available user group in server as below

    SQLServer2005SQLBrowserUser$MachineName

    SQLServerDTSUser$MachineName

    SQLServerFDHostUser$MachineName$MSSQLSERVER

    SQLServerMSASUser$MachineName$MSSQLSERVER

    SQLServerMSSQLServerADHelperUser$MachineName

    SQLServerMSSQLServerADHelperUser$MachineName

    SQLServerMSSQLUser$MachineName$MSSQLSERVER

    SQLServerReportServerUser$MachineName$MSRS10.MSSQLSERVER

    SQLServerSQLAgentUser$MachineName$MSSQLSERVER

    I do not want to add domain user into local administrators group. Could you tell me, alternatively how to assign for access the SSRS URL?

    Thanks

    ananda

  • April 23, 2011 at 4:42 am

    #1315118

    Hi,

    Normal domain user Id does not able to browsing SSRS Report at clinet machine. that same domain user Id added into Administrator group at server side after that domain user can able to bowsing SSRS reports.

    Could anyone suggestion me, Is it compulsory domain user Id added into administrator group?

    Thanks

    ananda

  • April 25, 2011 at 9:51 am

    #1315486

    No a report user does not have to be part of the admin group.

    What we did is create a Report Browser group in AD. Then we added that group to the Report Manager Security, and gave it Browser permission.

    Then just add the people you want to be able to use the reports to your Report Browser group in AD and you should be set.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply