• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 732
  • Last Modified:

SCCM Installation Errors

I am trying to setup a test environment with 3 laptops running Windows server 2008 R2 and a Cisco 2950 switch. I have a DC1 running on one machine (withVMware), a SQL Server 2008 on a second machine and would like to install SCCM on the third. When running the SCCM installation prereq check, I received the 'SQL Server sysadmin rights' and some other errors. ConfigMgrSetup log indicates that it "could not connect SQL server 'master' db". Can someone help me resolve this error?
0
parrtee18
Asked:
parrtee18
  • 6
  • 3
1 Solution
 
TarekIsmailCommented:
HI,
the user account running Configuration Manager Setup must be granted sysadmin role permissions for setup to succeed.
0
 
TarekIsmailCommented:
use the print screens below to do it for the account used to install SCCM
SNAG-0110.jpg
SNAG-0111.jpg
SNAG-0112.jpg
SNAG-0113.jpg
0
 
parrtee18Author Commented:
The account was created using your instructions. However, when rerun the installation prereq check the error still exists.
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
TarekIsmailCommented:
HI,

 the logged on user and site server machine account require administrative rights to the remote SQL Server computerso please make sure  the machine account and user account to be local administrator on SQL server.

If you configure a domain user account to run the SQL Server service instead of the local system account (SQL Server best practice), a Service Principal Name (SPN) must be configured for the domain user account in Active Directory Domain Services.

http://technet.microsoft.com/en-us/library/bb735885.aspx
0
 
anubhavsharma18Commented:
http://www.eggheadcafe.com/software/aspnet/30817653/move-or-setup-of-sql-database-toa-remote-server-fails.aspx

It says
"Resolved: This only occurs in the Prerequisite Checker, in actual setup it
is 100% Successful. (Reported to MS as Bug)."
0
 
TarekIsmailCommented:
HI parrtee18,

you can use SCCM 2007 SP2 CD direct to install the configuration manager , as this bug was reported for SCCM 2007 without any SP.

Good Luck!
Tarek Ismail
0
 
parrtee18Author Commented:
Not sure what you meant? So... I can ignore this error and proceed with the installation?
0
 
TarekIsmailCommented:
yes try to start the installation and ignore the error , if it is failed i recommend to use SCCM SP2 to run the SCCM installation prereq check.
0
 
TarekIsmailCommented:
any news about your installation , i hope to complete it
0
 
parrtee18Author Commented:
I have other errors to iron out before the installation. So I guess we can close this for now.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 6
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now