If the credentials used to create the action account does not have access to the Operations Manager database, use the following procedure to create new Run As account that will access the database.
To create a new Run As account for accessing the Operations Manager database
-
Log on to the computer with an account that is a member of the Operations Manager Administrators role for the Operations Manager 2007 management group.
-
In the Operations console, click the Administration button.
Note When you run the Operations console on a computer that is not a management server, the Connect To Server dialog box displays. In the Server name text box, type the name of the Operations Manager 2007 management server that you want the Operations console to connect to. -
In the Administration pane, expand Administration, expand Security, right-click Run As Accounts, and then click Create Run As Account.
-
In the Create Run As Account Wizard, on the Introduction page, click Next.
-
On the General page, do the following:
- Select Windows in the Run As
Account type list.
- Type a display name in the Display Name text box.
Note The display name you enter here becomes the Run As account you will add to a new Run As profile in the following procedure. - You can also type a description in the Description text
box.
- Click Next.
- Select Windows in the Run As
Account type list.
-
On the Account page, type a user name, password, and then select the domain for the account that you want to make a member of this Run As account, and then click Create.
To assign the new Run As account to the Operational Database Account Run As profile
-
In the Administration pane, expand Administration, expand Security, and then click Run As Profiles.
-
In the Run As Profiles pane, right-click Operational Database Account, and then click Properties.
-
In the Run As Profile - Operational Database Account dialog box, click the Run As Accounts tab.
-
Under Run As Accounts, click New.
-
In the Add Alternate Run As Account dialog box, click the Run As Account list, click the Run As account you created in step 5b in the previous procedure, click the computer that is hosting the Operations Manager database, and then click OK.
-
In the Run As Profile - Operational Database Account dialog box, click OK.
To grant SQL Server Login rights for the new account
-
On the Windows desktop, click Start, point to Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
-
In the Connect to Server dialog box, in the Server Type list, select Database Engine, in the Server Name list select the server and instance for your Operations Manager database (for example, computer\INSTANCE1), in Authentication list, select Windows Authentication, and then click Connect.
-
In the Object Explorer pane, expand Security, right-click Logins, and then select New Login.
-
In the Login - New dialog box, click Windows authentication, and then click Search.
-
In the Select User or Group dialog box, enter the user or group name that you used when you created the new Run As account, click Check Names, and then click OK.
-
In the Login - New dialog box, click OK.
To grant access to the Operations Manager database
-
On the Windows desktop, click Start, point to Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
-
In the Connect to Server dialog box, in the Server Type list, select Database Engine, in the Server Name list select the server and instance for your Operations Manager database (for example, computer\INSTANCE1), in Authentication list, select Windows Authentication, and then click Connect.
-
In the Object Explorer pane, expand Databases, expand Operations Manager, expand Security, right-click Users, and then click New User.
-
In the Database User - New dialog box, type a name for this new user in the User name text box, and then click the ellipses (…) next to the Login name option.
-
In the Select Login dialog box, click Browse.
-
In the Browse for Objects dialog box, click the check box next to the new login, and then click OK.
-
In the Database User - New dialog box, in the Database role membership list, select dbmodule_users, and then click OK.
See Also
Did you find this information useful? Please send your suggestions and comments about the documentation.