Cannot create SQL database during SCCM 2007 SP1 installation

Today I’ve installed a new System Center Configuration Manager 2007 environment. During the installation, I get the following error “The site server computer’s machine account does not have Administrator’s previleges on the SQL Server selected for site database installation. To install a Configuration Manager site, all servers must be in an Active Directory domain and the site server’s machine account must have Administrator’s privileges on the SQL Server”.

To fix this problem, you’ll need to do the following steps:

1.) On the SQL Server, right-click My Computer and select Manage to open the Computer Management console
2.) Expand the Local Users and Groups node and select Groups
3.) Double-click Administrators in the right-hand pane of the Computer Management console
4.) Click the Add… button to open the Select Users, Computers and Groups dialog box
5.) Click the Object Types… button and ensure Computers is selected in the Object Types dialog box. Click OK to return to the Select Users, Computers and Groups dialog box
6.) If the From this location field in the Select Users, Computers and Groups dialog box does not show the domain that the Configuration Manager site server is in, click the Locations… button and select the correct domain
7.) In the field labelled Enter the object names to select, type the computer name of the Configuration Manager site server. Click the Check Names to confirm that the name has been recognised
8.) Click OK

SCCM_DB_01    SCCM_DB_02    SCCM_DB_03

SCCM_DB_04

Leave a Reply