My fourth attempt at installing SCCM 2012

ok today I am going to try to install SCCM 2012 again! Yup….this time is going to be my fourth attempt after three unscuccessful installation attempts.

This time I am going to use a remote SQL server which is running on a 64bit OS. In my last attempt, I determined that the remote SQL server needs to be running on a 64bit OS. Note that I have already updated the SQL server as per the minimum requirements of SCCM 2012. Here it goes…

 

 

 

 

Updating SQL Server 2008 R2 for use with SCCM 2012

ok folks…here is how I upgraded my SQL server 2008 R2 instance to the version SCCM requires

SQL Server 2008 R2 with SP1 and with a minimum of Cumulative Update 6

First, lets download CU6 from here.

After installing CU6 the SQL log file shows that I have this version:

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2811.0 (X64)

So that equates to SP1 CU #6 (2679367) Apr 16, 2012

Ok so that should satisfy the requirements of SCCM 2012.

My third attempt at installing SCCM 2012

Today I am making another attempt at installing SCCM 2012. Who knew it would be this difficult just to install SCCM! Wow.

Anyway, I am running the installer again….At the database config screen I am entering the same old information of my database….lets see if that works this time. Ooops! error! Here is what it looks like:

Ok….lets take a look at that KB article…

Nothing comes off as wrong to me. so I look into the setup log file which is c:\ConfigMgrSetupWizard.log

I see this message at the bottom:

5/24/2012 11:20:57 AM: ConfigMgrSetupWizard Information: 1 : Creating SQL connection to database master on server xxx.xxx.com. 5/24/2012 11:20:58 AM: ConfigMgrSetupWizard Information: 1 : Sql connection is established. 5/24/2012 11:20:58 AM: ConfigMgrSetupWizard Information: 1 : Creating SQL connection to database master on server xxx.xxx.com. 5/24/2012 11:20:58 AM: ConfigMgrSetupWizard Information: 1 : Sql connection is established. 5/24/2012 11:20:58 AM: ConfigMgrSetupWizard Error: 1 : Unsupported SQL version 10.50.2500.0

uh-oh…. 🙁 I am actually trying to connect to a wrong DB server! The DB server which I updated earlier [I blogged about the procedure here] is a different DB server. My bad!

Lets correct it. done…. after that I still get an error. This time it is different:

 

5/24/2012 12:01:11 PM: ConfigMgrSetupWizard Error: 1 : Exception message: [A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 – No connection could be made because the target machine actively refused it.)], Exception details: [System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 – No connection could be made because the target machine actively refused it.)

This is very strange…

{Eureka moment comes now!}

I solved the issue…or rather I found out what I was doing wrong. Since I am NOT using a named instance for SCCM 2012… I am required to use dymanic ports in SQL server TCP/IP config. According to all documentation and blogs I am supposed to disable dynamic ports. However that is valid ONLY if you use a named instance for SCCM. If you are [strange] like me…trying to use a default instance for SCCM2012….you gotta enable dynamic ports for TCP/IP.

I was blindly following blogs like these without customizing the instructions for my own situation!..oh well 🙁

Anyway, after correcting the problem, the installer proceeds normally and comes to the prerequisite check. At that point it give me 4 warnings [none of them are show stoppers]. I click on the “Begin Install” button with bated breath 🙂

No luck 🙁 I got this error:

Upon googling I found this thread. I tried the suggestion:

 After reviewing a trace of the installer running, they found it failing to create the certificate because the CNG Key Isolation (KeyIso, lsass.exe) service was not running.

That did not work 🙁 for me.

The second suggestion is:

Make sure the service account running your SQL services is in the local administrators group so that it also takes ownership and full control of the directory and that should allow the SCCM install to assign the self-signed certificate via that account.

Trying out this one now and re-running the install……and NO…that did not fix it either 🙁

Then I found another web page. It talks about deleting a registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS

Nope! that did not work either!

There is a SPN suggestion which I am going to try out next at this web page:

I’ve set my sql spn like this:

setspn -A MSSQLSvc/S-SCCM.domain.local:1433 mydomain\SQLService

setspn -A MSSQLSvc/S-SCCM:1433 domain\SQLService

SQLService is your SQL service account

domain is your domainname

1433 is the default port

This is the technet howto: Link

Too bad…it still did not work. I am running out of options here 🙁

Lets try deleting the registry key [discussed above] and try again…

no luck! This sucks!

ok, so my nice DBA pointed me to a webpage where this guy is talking about creating a certificate manually. Hmmm I saw this page yesterday. Lets try it out.[later] well this did not pan out…I dont have a CA here in our AD. However, I foung another web page which talks about “My remote SQL server already has an certificate set up for Server Authentication” and still it does not work.

So MAYBE I need a 64bit OS for the SQL box? Lets see if I can build a 64bit VM for this test.

ok so we already  have a SQL server 2008 R2 database running on Windows 2008 R2 64bit here. It is an RnD server so I can play around with it. Lets start updating it.

 

My second attempt on installing SCCM 2012

This is the second part of my installing SCCM series. Read the first part here

So I ran the setup again and at the “Database Information” page it seems to get stuck. I got the same “unable to connect” error as last time. troubleshooting…

Updated 5/24/2012: See my third attempt at installing SCCM 2012