Setting up access for the anonymous user
If you are using the short_drinks sample in UNICOM Intelligence Reporter - Survey Tabulation, you need to carry out the following additional steps after you restore the sample database, to grant access to the anonymous user.
The procedure for granting access depends on the version of the SQL Server client tools that you are using.
To use Microsoft SQL Server to grant access
1 Open SQL Server Management Studio.
2 In the Object Explorer pane, click + next to the server on which you want to grant access.
3 Expand the Security node.
4 Right click the Logins node, and then click New Login. This opens the Login - New dialog box.
5 In Login name, add the name of the UNICOM Intelligence Interviewer - Server Admin (or UNICOM Intelligence Reporter - Survey Tabulation) user group you created, in the form localcomputer\usergroupname. For example, MyInterviewServer01\MyUsersGroup.
6 At the top left of the Login - New dialog box, in "Select a page", click the Server Roles tab and select dbcreator.
7 In "Select a page", click the User Mapping tab.
8 In "Users mapped to this login", select the short_drinks database.
9 In "Database role membership for: short_drinks", select db_owner and public.
10 Click OK. SQL Server grants the access.
Requirements
SQL Server Client Tools
See also