Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

How to: Grant Database Permissions to a Subscription Management Interface

SQL Server 2005

This procedure shows how to grant database permissions to the account used by a subscription management interface. The account used can be either a Microsoft Windows account or a SQL Server Login account. This procedure assumes that the account has already been granted permissions to log in to SQL Server.

ms171380.note(en-US,SQL.90).gifNote:
The default instance database name is instanceNameNSMain. The default application database name is instanceName + ApplicationName. However, in SQL Server 2005, you can specify the database name in the instance configuration and application definition.

  1. In SQL Server Management Studio Object Explorer, expand Databases.

  2. For the instance database and each application database, do the following:

    1. Expand the database.
    2. Right-click the Security folder, point to New, and then select User.
    3. In the User name box, enter a name for the database user.
    4. In the Login name box, enter the name of the login.
      The login name must exactly match the name of an existing login in the instance of SQL Server. Click the Search button to search for the login name.
    5. In the Database role membership box, select NSSubscriberAdmin.

The following code shows how to grant database permissions to the account used by a subscription management interface:

USE [InstanceNameNSMain];
CREATE USER [MyLogin];
EXEC sp_addrolemember N'NSSubscriberAdmin', N'MyLogin';
USE [InstanceNameAppName];
CREATE USER [MyLogin];
EXEC sp_addrolemember N'NSSubscriberAdmin', N'MyLogin';
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.