Skip to content

SCCM2012 on SQL 2008 R2 cluster

Featured Replies

Hello,

I have a problem installing SCCM 2012 on the SQL 2008 R2 cluster. When it goes through the prerequisites, and I specify my SQL server, it connects fine, but when it comes to creating the database on the server it fails, saying that it can’t connect to the server.

I tried a different approach and installed a local copy of SQL 2008 R2. SCCM installed fine. I moved the database to the SQL cluster, tried to re-point to use cluster and it failed again. Here is some log from the attempt to re-point to cluster:

 

INFO: SQL Connection succeeded. Connection: clustername.domain MASTER, Type: Unsecure $$<Configuration Manager Setup><04-27-2012 10:32:34.107-60><thread=4056 (0xFD8)>

INFO: SQL Server clustername.domain is clustered. $$<Configuration Manager Setup><04-27-2012 10:32:34.193-60><thread=4056 (0xFD8)>

*** [08001][-2146893022][Microsoft]

SSL Provider: The target principal name is incorrect.~~  $$<Configuration Manager Setup><04-27-2012 10:32:34.202-60><thread=4056 (0xFD8)>

*** [08001][-2146893022][Microsoft][sql Server Native Client 10.0]Client unable to establish connection $$<Configuration Manager Setup><04-27-2012 10:32:34.202-60><thread=4056 (0xFD8)>

*** Failed to connect to the SQL Server. $$<Configuration Manager Setup><04-27-2012 10:32:34.202-60><thread=4056 (0xFD8)>

INFO: SQL Connection failed. Connection: SMS ACCESS, Type: Secure $$<Configuration Manager Setup><04-27-2012 10:32:34.202-60><thread=4056 (0xFD8)>

 

I tried to connect using the ODBC connection, name resolution and it was ok. Then I tried to use IP address instead of the name and I also used domain admin account and the same result.

I would appreciate your help.

  • Author

Problem solved.. Instead of using the SQL 2008 R2 Native client on the primary site, i shuld have used the 2008 one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.