2

I've run into SQL database connection issues while trying to install SCCM 2007 SP2.

I have a VM setup that hosts SQL Server 2008 R2 SP2 installed using default settings and setting the services to run using a new domain account named 'SCCMAdmin'. During the install I've told the SQL installer to make the SCCMAdmin a sysadmin.

During the SCCM install I get stopped by the following error.

SCCM Error

I've confirmed local and remote access using a ODBC connector and remote SQL editors with successful logins.

ODBC Successful Test

I've been over at least a hundred sites complaining about SQL database access and some getting resolved by adding the system account to the SQL server as an admin and other solutions but none have worked.

My SPN is setup properly. SPN

I'm not sure what I'm missing.

SCCMAdmin credentials: SCCM Credentials

I will be grateful for any suggestions.

Devin Rawlek
  • 71
  • 7

1 Answers1

0

So after many hours of fighting I gave up and wiped the server. A clean install is what was needed as the setup completed without issue this time.

So much wasted time but I have a working SCCM environment now.

Devin Rawlek
  • 71
  • 7
  • I later found out it was a botched SQL server install. Something went wrong during the install as I ran into it again later on and found that reinstalling the SQL server resolved the issue. However this is not a great solution if your environment is already in use. – Devin Rawlek Jan 04 '14 at 23:25