{"id":264,"date":"2012-05-24T11:15:22","date_gmt":"2012-05-24T15:15:22","guid":{"rendered":"http:\/\/rajdude.com\/blog\/?p=264"},"modified":"2012-05-29T10:41:34","modified_gmt":"2012-05-29T14:41:34","slug":"my-third-attempt-at-installing-sccm-2012","status":"publish","type":"post","link":"https:\/\/rajdude.com\/blog\/my-third-attempt-at-installing-sccm-2012\/","title":{"rendered":"My third attempt at installing SCCM 2012"},"content":{"rendered":"

Today I am making another attempt at installing SCCM 2012. Who knew it would be this difficult just to install SCCM! Wow.<\/p>\n

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:<\/p>\n

\"\"<\/a><\/p>\n

Ok….lets take a look at that KB article…<\/p>\n

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

I see this message at the bottom:<\/p>\n

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<\/strong><\/p>\n

uh-oh…. \ud83d\ude41 I am actually trying to connect to a wrong DB server! The DB server which I updated earlier [I blogged about the procedure here<\/a>] is a different DB server. My bad!<\/p>\n

Lets correct it. done…. after that I still get an error. This time it is different:<\/p>\n

 <\/p>\n

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.)<\/p>\n

This is very strange…<\/p>\n

{Eureka moment comes now!}<\/p>\n

I solved the issue<\/strong>…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<\/em>. 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<\/em> for TCP\/IP.<\/p>\n

I was blindly following blogs like these<\/a>\u00a0without customizing the instructions for my own situation!..oh well \ud83d\ude41<\/p>\n

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 \ud83d\ude42<\/p>\n

No luck \ud83d\ude41 I got this error:<\/p>\n

\"\"<\/a><\/p>\n

Upon googling I found this thread<\/a>.\u00a0I tried the suggestion:<\/p>\n

\u00a0After 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.<\/p><\/blockquote>\n

That did not work \ud83d\ude41 for me.<\/p>\n

The second suggestion is:<\/p>\n

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.<\/p><\/blockquote>\n

Trying out this one now and re-running the install……and NO…that did not fix it either \ud83d\ude41<\/p>\n

Then I found another web page<\/a>. It talks about deleting a registry key:<\/p>\n

HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\SMS<\/pre>\n
Nope! that did not work either!<\/p>\n
There is a SPN suggestion which I am going to try out next at this web page<\/a>:<\/p>\n
I’ve set my sql spn like this:<\/p>\n
setspn -A MSSQLSvc\/S-SCCM.domain.local:1433 mydomain\\SQLService<\/p>\n
setspn -A MSSQLSvc\/S-SCCM:1433 domain\\SQLService<\/p>\n
SQLService is your SQL service account<\/p>\n
domain is your domainname<\/p>\n
1433 is the default port<\/p>\n
This is the technet howto: Link<\/a><\/p><\/blockquote>\n
Too bad…it\u00a0still did not work. I am running out of options here \ud83d\ude41<\/p>\n
Lets try deleting the registry key [discussed above] and try again…<\/p>\n
no luck! This sucks!<\/p>\n
ok, so my nice DBA pointed me to a webpage where this guy is talking about creating a certificate manually<\/a>. 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\u00a0foung another web page <\/a>which talks about “My remote SQL server already has an certificate set up for Server Authentication” and still it does not work.<\/p>\n
So MAYBE I need a 64bit OS for the SQL box? Lets see if I can build a 64bit VM for this test.<\/p>\n
ok so we already\u00a0 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<\/a>.<\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
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…. \ud83d\ude41 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\u00a0without customizing the instructions for my own situation!..oh well \ud83d\ude41 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 \ud83d\ude42 No luck \ud83d\ude41 I got this error: Upon googling I found this thread.\u00a0I tried the suggestion: \u00a0After 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 \ud83d\ude41 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 \ud83d\ude41 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\u00a0still did not work. I am running out of options here \ud83d\ude41 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\u00a0foung 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\u00a0 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.  <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[37,29],"class_list":["post-264","post","type-post","status-publish","format-standard","hentry","category-itsys","tag-sccm-2012","tag-system-administration"],"_links":{"self":[{"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/posts\/264","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/comments?post=264"}],"version-history":[{"count":22,"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/posts\/264\/revisions"}],"predecessor-version":[{"id":268,"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/posts\/264\/revisions\/268"}],"wp:attachment":[{"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/media?parent=264"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/categories?post=264"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rajdude.com\/blog\/wp-json\/wp\/v2\/tags?post=264"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}