Granting Access to the Database and Publication
When you create a publication, Microsoft SQL Server creates a publication access list (PAL) for the publication. The PAL is similar to an access control list (ACL) in Windows. To give a SQL Server 2005 Compact Edition (SQL Server Compact Edition) subscriber access to a publication, you must add the appropriate user account to the SQL Server Logons, and then add the user account to the PAL.
Configuring Database Access
Before adding a user to the PAL, you must first grant database access to the appropriate user account, based on how you configured Microsoft Internet Information Services (IIS) and SQL Server Authentication. Use the following table to determine which user account the Merge Agent uses.
| IIS authentication mode | Authentication mode on the SQL Server | Add this user account: |
|---|---|---|
Anonymous access |
Windows Authentication |
computername\IUSR_computername, or the configured IIS anonymous user account. |
Basic authentication |
Windows Authentication |
The IIS client's user account or group. |
Integrated Windows Authentication |
Windows Authentication |
The IIS client's user account or group. This configuration is only supported if SQL Server and IIS are running on the same computer. |
Anonymous, Basic, or Integrated Windows Authentication |
Windows Authentication |
The user specified in the DistributorLogin or PublisherLogin property of the Replication object. |
Granting Access to the Publication
When the user account has been granted database access, you can add the account to the PAL.
Important
If the Publisher and Distributor are on different computers, you must add the user account to the PALs for both the Publisher and the Distributor. If the IIS user (in the case of Windows Authentication) or the SQL Server logon (in the case of SQL Server Authentication) is not contained in the PAL, an Access Denied message is displayed at the Subscriber.
See Also
Tasks
How to: Grant Access to the Database and Publication
Concepts
Securing the Publication
Configuring the Merging Changes Option