19 February 2009

pre-Reqs for Service Manager

For those who are like me who just wouldn't be interested in reading installation notes and eventually got burnt. I will be kind enough to share this with

you after having my hands charred a couple of times.

One of the key pre-Reqs when you want to install and configure Service Manager is to get you action accounts configured properly. Here I have copied

excerpts from the Initial Config guide and let it be our light ...

1) Create an Active Directory group of users that will be assigned to the role of Service Manager administrators of both the data warehouse and Service Manager management groups. For example, create the group SM_Admins. This group of users must be in the same domain that Service Manager is in. Users from any other domain, even child domains, are not supported.

2)For the account you use to run Setup, verify the following:

  • Must be a SQL Server sysadmin on the SQL server where you install the databases.
  • Must be a member of the data warehouse management group administrators. For example, add this account to the SM_Admins group.
3)Identify or create a domain account that will be used for the Service Manager account. For example, create the domain account SM_Acct.
  • This account must be in the same domain that Service Manager is in. Accounts from any other domain, even child domains, are not supported.

4) For the domain account, for example, SM_Acct, make sure of the following:


  • The domain account is a member of the group you created in step 1. For example, make the domain account SM_Acct a member of the SM_Admins group.
  • The domain account is a member of the local administrator group on the computer that will host the Service Manager management server and the data warehouse server.
  • The domain account is a member of the sysadmin role for the data warehouse SQL Server as well as for the Service Manager database SQL ServerThe domain account is a member of the Content Manager role (or higher) in SQL Server Reporting Services.
5)Make sure that the SQL instances used for Service Manager databases are using port number 1433.
6)If you are installing the databases on a remote computer running SQL Server, the computer account (for
example, $) of the computer you are running Setup on must be a local administrator on the SQL Server computer.