Seen while installing System Center Configuration Manager 2007
Error: Setup cannot complete the specified installation on this computer for the following reasons. The site server computer’s machine account does not have Administrator’s privileges on the SQL server selected for the site database installation. To install a Configuration Manager site, all servers must be in an active directory domain and the site servers machine account must have Administrator’s privileges on the SQL Server.
Solution
First log onto the SQL server you are using to store the SCCM database.
If the SQL Server is a Domain Controller
1. Click Start > Run > dsa.msc {Enter}.
2. Expand the domain-name > Builtin > Administrators > Right Click > Properties > Members > Add > Object Types > Tick “Computers” > Then add in the server name of the SCCM Server > Apply > OK.
If the SQL Server is a Member Server
1. Click Start > Right Click Computer (or my computer) > Manage.
2. Expand Configuration > Local Users and Groups > Groups > Administrators >Right Click > Properties > Members > Add > Object Types > Tick “Computers” > Then add in the server name of the SCCM Server > Apply > OK.
Finally re-try the SCCM installation.
Related Articles, References, Credits, or External Links
I had to work out how to do this for a client, and as is my modus operandi, I’ll try and save you some of the pain I endured,
Products Used
System Center Configuration Manager 2007 SP2 Windows Server 2008 R2 SQL 2008 R2 (At time of writing neither officially supported or not supported on SCCM)
Note: I was originally going to use SQL 2005 – hence the reason the SQL servers name is SCCM-SQL2005, however I bit the bullet and used SQL 2008 R2 instead.
Solution
Step 1: SCCM Domain pre install work.
1. Create two groups in Active Directory.
a. sccm administrator group SCCM-ADMIN b. sql administrator group SQL-ADMIN
2. Add both groups to the Domain Admin’s group.
3. Create two new users: sccmadmin and sqladmin.
4. Add sccmadmin to SCCM-ADMIN group and add sqladmin to SQL-ADMIN group.
c. Windows Authentication. d. IIS6 Metabase compatibility. e. IIS6 WMI compatibility.
3. Add the following “server Features”:
a. Background Intelligent Transfer Service. b. Remote Differential Compression.
4. If you are NOT running Windows Server 2008 R2 Download and install WebDav (already included in Windows Server 2008 R2). If you are running R2 skip to the next step.
5. Server Manager > Roles > Web Server (IIS) > Add Role Services > WebDAV Publishing > Next > Close.
6. To enable WebDav > Start > Administrative Tools > Internet Information Services (IIS) Manager > Expand {server name} > Sites > Default Web Site > WebDav Authoring Rules.
7. Select Enable WebDav (On the right hand side).
8. Select add authoring Rule > All Content > All Users > Permissions > Read > OK.
9. Select the rule you have just created > WebDav Settings.
10. Change “Allow Anonymous Properties Queries” to True > Change “Allow Custom Properties” to False > Change “Allow Property Query with Infinite Depth” to True > Change “Allow hidden files to be listed” to True > Apply.
12. From the WSUS installation choose “Full server installation” > DO NOT accept the default “Use the existing IIS Default Web site” > Use “”Create a Windows Server Update Services 3.0 SP2 Web site” (Note: this will use port TCP 8530 by default).
Step 3: SCCM Install SQL Server.
1. From the SQL install media run setup.exe > Installation > “New Installation or add features to an existing Installation” > OK.
2. Enter product Key if applicable > Next > “I accept…” > Next > Install > Next > Next.
5. On the Server configuration Page > Select “Use the same account for all SQL Server services > Select the User you created originally (sqladmin) > Set the SQL Server Agent and SQL Server Database Engine Startup type to “Automatic” > Next.
6. Accept “Windows Authentication” > Add in your SCCM-ADMIN group and SQL-ADMIN group > Next > Next > Next > Install.
7. When it’s completed click close.
Step 4: Prepare Active Directory for SCCM
1. Extend the schema > From the install media > SMSSETUP > BIN > 1386 > extadsch.exe
2. Check the above was successful by opening the c:extADsch.txt file it should say “”successfully extended the Active Directory Schema”.
3. We now need to create some active directory objects go to a domain controller > Start > Administrative tools > ADSI Edit > Action > connect to > leave everything on its defaults > OK.
4. Expand the Default naming context > Expand your domain name > Right click “system” > New > Object > Container > Next.
5. Call it “System Management” > Next > Finish > Close ADSI Edit.
6. Still on the domain controller > Start > dsa.msc {enter} > View > Advanced.
7. Expand “system” > Locate the container you created “System Management” > right click it and select properties > Security Tab > Add > Object Types > Tick Computers > OK.
8. Click Advanced > Find Now > Locate and add the SCCM-ADMIN group you created earlier > Also add the SCCM Server itself > OK.
9. Grant allow “Full Control” to both the SCCM admin group and the SCCMserver.
10. Now click advanced > Select the SCCM-ADMIN group > Edit.
11. Change the “Apply to” section from “This object only” to “This object and all descendant objects” > OK > Apply > OK.
12. Repeat the above for the SCCM-Server object.
Step 5: Install SCCM
1. Log on as the sccadmin user.
2. From within the SCCM setup media run splash.hta > Run the Pre requisite checker > Enter the SQL Server name > SCCM server name and the FQDN of the SCCM server > OK.
3. Note If you cannot talk to the SQL server then check that the Windows firewall is not blocking you (on the SQL server Start > run > firewall.cpl > Turn it off).
4. All being well it should say “All required pre requisite tests have completed successfully” > OK.
5. Re-run Splash.hta > This time choose > Install configuration Manager 2007 SP2 > Next > “Install Configuration Manager site Server > Next.
6. Tick “I accept these License terms > Next > Custom Install > Next > Primary Site > Next > Next > enter unlock code is applicable > Next > Accept/change the install directory > Next > Enter a Site code and friendly name > Next.
DO NOT ever try and change this code and don’t forget it!!
7. Change the Site mode to “Configuration Manager Mixed Mode” (Native mode requires certificate services and considerably more work). > Next.
8. Accept the defaults (everything except NAP) > Next.
9. Enter your SQL server name > Next > Next > Next > Next > Next.
10. Select a location to install the updates to > Next.
11. Updates will download this may take some time > when finished it should say it was successful > OK > Next.
12. It will run the pre requisite check again > when finished click begin install.
13. When finished click Next > Finish.
14.Now you need to send out the clients and configure SCCM, I’ll cover that in a later article.
Related Articles, References, Credits, or External Links
You have a reference machine (physical or virtual), and you want to capture an image of that machine to your System Center Configuration Manager 2007 Infrastructure.So you can then deploy that image to multiple machines.
2. Download the Task and Registry File in Zip Format (Edit the .reg file with notepad to enter the correct administrator password see below).
3. Create a SHARE on your network to hold the images and files > and grant full control to your sccadmin user.
4. Windows and application media that is either “Volume Licensed” or “Multiple Activation Licensed”.
5. Your Windows 7 reference machine needs the local administrators account enabling, and the local administrator’s password changing to mach the password in the registry file you downloaded above. (In the example below Password123).
[box]
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionWinlogon]
"AutoAdminLogon"="1"
"DefaultUserName"="Administrator"
"DefaultPassword"="Password123"
[/box]
Step 1: SCCM Put your Reference Machine into a Collection
1. Open the SCCM Manager > Expand Site Database > Computer Management > Collections > Right Click > New Collection > Call It “Image Reference Machine” > Next.
2. Next > Click the small computer Icon to add a rule > Next > Change the Resource Class to “System Resource” > Change the attribute name to “Name” > Enter the reference machines Name.
3. Supply the “All systems” Collection > Next.
4. Select your Reference Machine > Next
5. Set the schedule so it occurs 5 minutes in the future > OK > Next > Next > Finish.
6. When finished you should have your Reference Machine in the Collection.
Step 2: SCCM Create an “AutoLogon Package”
1. Open the SCCM Manager > Expand Site Database > Computer Management > Software Distribution > Right Click > New > Package > Call it AutoLogon > Next.
2. Tick “This Task contains source files” > Put in the path to share containing the AutoLogon.reg file > Next.
3. Next > Next > Next > Next > Next > Close
4. Expand Your AutoLogon Package > Programs > Right Click > New > Program > Call it “AutoLogon” > In the Command Line Section enter reg import “AutoLogon.reg” > Next.
5. Next > In the Environment Section change the “Program Can Run” Section to “Whether of not a User is Logged on” > Tick Run with Administrative rights > Tick “Runs with UNC Name” > Next.
6. Next > Next > Next > Next > Close.
7. Expand your AutoLogon Package > Distribution Points > Right Click > New Distribution Point > Next > Tick the Server > Next > Close.
8. Extract the AutoLogon.reg file to the location you specified in number 2 above.
Step 3: SCCM Import the “Windows 7 Import Task”
1. Extract the Windows7_Capture_Task.xml file to the Desktop.
2. Launch the SCCM Manager > Expand > Site Database > Computer Management > Operating System Deployment > Task Sequences > Right Click > Import > Select the Windows7_Capture_Task.xml from your desktop.
3. You Will be asked if you want to Edit the Task Select Yes > Under “Autologin Via Registry” Select the Package you created in Step 2 above.
4. In the Capture The Reference Machine Section > Set the Network share you want to save the Image in > Set an account (Note user DOMAINNAMEusername) that account MUST have permissions to the network share > Apply > OK.
5. Right Click the Task you have just imported > Properties > Advanced > Tick “Use Boot Image” > Select either the x86 or x64 (to match your reference machine) > Apply > OK.
6. Right Click the Task you have just imported > Advertise > Under Collection Set your “Reference Image Machine” > Next.
7. Next > Next > Next > Next > Close.
Step 6: SCCM Send the Boot Media to Distribution
1. Launch the SCCM Manager > Expand > Site Database > Computer Management > Operating System Deployment > Boot Images > Boot Image (x86) > Distribution Points > Right CLick > New Distribution Points > Next.
2. Select the Server share > Next
3. Check the settings > Next.
3. Repeat the above for the Boot Image x64
Step 7: SCCM Create Task Sequence Media
1. Right click the Task you have created > Create Task Sequence Media.
2. Capture Media > Next.
2. Save the ISO image to the network share you created earlier.
Step 8: SCCM Perform the Capture
1. Boot Your Windows 7 Reference Machine > Start > Control Panel > Run Advertised Programs > Select “Windows 7 Capture Task” (If it’s not there, reboot and apply the cup of coffee rule) > Run > Yes.
2.The machine will reboot then “Prepare ConfigMgr Client.”
3. Then it will run sysprep.
4. Then it will reboot again, sccm will launch.
5. The Machine will start to capture.
6. Capturing can take a LONG! time
7. When finished the machine will reboot and (because its been sysprepped) will rebuild itself.
8. Your Image file will be in the network share you defined in step xx above with the name you specified in step xx above
Related Articles, References, Credits, or External Links
