IBM Performance Management

Creating a user and granting required permissions

Before you configure the Microsoft SQL Server agent, you must create a user (login) on the Microsoft SQL Server and grant permissions to the user to monitor the Microsoft SQL Server. The process of granting permissions is the same for SQL Server 2005, or later.

Before you begin

Ensure that you have the database administrator authorization role (sysadmin) to create a user and grant permissions to the user.
Ensure that the SQL Server ID that you use to configure the SQL agent must have the following SQL Server authorization roles:
- Database roles: Public access is required for each database that is being monitored.
- Server roles: Sysadmin role is required.

About this task

You grant permissions to SQL Server login ID so that agent can monitor the Microsoft SQL Server. Complete this task before you configure the agent.

Procedure

Click Start > Programs > Microsoft SQL Server 2008 > SQL Server Management Studio.
In the Tree tab, select Logins in the Security folder (Console Root > InstanceName > Security > Logins).
Right-click Logins and select New Login.
Select the General Folder option and type one of the following options:
- SQL Server user ID
  If you are using SQL Server authentication.
- Windows user ID
  If you are using Windows authentication.
Select one of the following authentication methods:
- SQL Server
- Windows
In the Password field, type a password if you are using the SQL Server authentication method.
In the Confirm Password field, retype the password that you entered in the Password field.
Select Server Roles and add the sysadmin role to the new login ID. By default, the public role is given to new login ID.
Select User Mapping.
In the Specify which databases can be accessed by this login area, select the check box corresponding to each database for which you want to grant permissions.
Click OK to display the new login ID in the Logins list.