Setting up anonymous access for Reporting Services publishing Web Reports in SQL Server 2005

Original: Anonymous access to the Reporting Services publishing Web Report is set in SQL Server 2005

A friend raised a question: integration into SQL Server 2005 in the Reporting Services the report template has been published to IIS server, when the client accesses through the browser, the default pops up Windows The Integrated Authentication dialog box. If the option to allow Anonymous (iusr_**) access is checked in the IIS configuration, the client will be prompted to visit again iusr_** Insufficient access rights.

for this issue, in addition to setting IIS to allow anonymous access, you also need to set Reporting Services the site's access rights and SQL Server user access rights in the data source.

below, I will list the steps that need to be taken, and the premise is to use Visual Studio. NET 2005 It's been released correctly. Reporting Services the report template that you made to IIS server.

First step: Local access to the Web server running IIS http://localhost/reports , this is Reporting Services the management site, in Properties (properties) page, add a Browser New for (browser) permissions Role (role). Note the user name of the new role is iusr_** (anonymous user).

1. Click on the " New Role Assignment (assign new role)

2. pop-up IE window, Group or user name (group or user name) text Box Input iusr_** (anonymous user).

3. Tick Browser (browser) permissions, click OK button to determine.

4. return to http://localhost/reports the page will appear with the newly added Role (role).

Step two: In addition to settingReporting Servicesof theIISsite can allowiusr_**(anonymous user), you first need to set theSQL Server 2005the corresponding database in the data can allowiusr_**(anonymous user) has read-only access rights.

in the Run SQL Servier 2005 database server, open the Microsoft SQL Server Management Studio . Locate the Logins(login) in theSecurity directory in the object Explorer, Logins(login) icon on the right-click shortcut menu, select New login ... (new login), the popup dialog box is set.

1. Right-click menu selection New Login ... (new login).

2. in the Windows Authentication in the Login Name (logon name) text box, enter iusr_** (anonymous user).

3. in the Defaults (the default) Database (database) drop-down list box to find Reporting Services The data source database for the produced report template.

4. in the Select a page (select a page) in the list, click " Database Access "(Database access).



step three: in Data Access page, in Databases accessible by this login (database default login) selection Reporting Services The data source database for the produced report template.

1. Select Database

2. OK Determine

 

The fourth step: still in Microsoft SQL Server Management Studio , locate Reporting Services data source database, in the Security " (SAFE)" Users "(user), find what you just added iusr_** (anonymous user). Set his access rights to the database.

1. in the iusr_** (anonymous user) on the right-click menu, select Properties (properties).

2. in the popup dialog box, select Permissions (license).

3. Click on the " Add Objects ... (Increase the object).

4. in the dialog box that pops up again, select ADD objects of types ".

Fourth Step: Select Databases (Database) in the dialog box that pops up .

1. Select Object Types (Select Object Type) dialog box to select the Databases "(database).

2. OK OK.

  or the Fourth step: Selectiusr_**(anonymous user) the operation that the database is licensed to.

1. in the Permissions for * * * list, locate Select , tick the box. (Note: You will see that Connect is followed by the default check, because the default login to the database is the database)

2. OK OK.

  Fifth step: OpenIISManager, settingReportServerThe virtual directory is anonymous access.

1. Open IIS Manager, in ReportServer on the virtual directory, click Mail Selection. Properties "(attribute).

2. on the Directory Security page, locate authentication and access control, click Edit ... ".

3. in the "Authentication Method" dialog box that pops up, check "Enable anonymous access."

4. in the location where user access needs to be authenticated, the default is to select the integration Windows Authentication ". There is no need to modify it here. If you remove the check in front of integrated Windows authentication, this machine (theIIS Server's machine) is Reporting access to the Services Web site is also an anonymous access.

5. OK OK.

  Sixth step: Re-access through other client machinesReporting Services Website, it no longer appearsWindowsUser Login window. TheReporting Services Webaccess to the site has changed to anonymous user access.

  

but note that there is a problem that will occur at the same time. When we visited http://localhost/reports again , we found that the rights of Reporting Services could not be assigned. Open http://localhost/reports can see only Contents(content) A category page option, " theProperties option does not appear. This should be Reporting Services Products deliberately designed, because all users can access the Web site anonymously, permissions if you let go of any change is certainly not.

think again, http://localhost/reports and http:// Localhost/reportserver The physical directories that correspond to the two virtual directories are different. A http://localhost/reports corresponds to c:\program Files \microsoft SQL server\mssql.3\reporting Services\ReportManager , and http:// Localhost/reportserver corresponds to c:\program Files\Microsoft SQL Server\mssql.3\ Reporting services\reportserver . How does the modification of the anonymous access rights for \reportserver affect the \reports ??

If you need to modify it again \reports of " Properties "(attribute), the only thing that can be done is to reopen IIS the manager, remove \ReportServer in the "Anonymous access" option, and then modify it. Once modified, change the \reportserver to "Anonymous access".

Setting up anonymous access for Reporting Services publishing Web Reports in SQL Server 2005