Answered by:
SCCM 2012 Installation : Setting up the database failed with error "ERROR: SQL Server error: [08001][27][Microsoft][SQL Server Native Client 10.0]Registry information is corrupt or missing."

Question
-
Hello Experts,
I am actually new with System Center technologies. I am in process of Installing SCCM2012 and the database server which I am using for it is SQL Server2008 R2 SP3 CU4. Due to some reasons, I am unable to install it successfully as it fails with error :
ERROR: SQL Server error: [08001][27][Microsoft][SQL Server Native Client 10.0]Registry information is corrupt or missing. Make sure the provider installed and registered correctly. $$<Configuration Manager Setup><06-21-2012 21:49:35.049-330><thread=2064 (0x810)>
*** [08001][27][Microsoft][SQL Server Native Client 10.0]Client unable to establish connection $$<Configuration Manager Setup><06-21-2012 21:49:35.049-330><thread=2064 (0x810)>
ERROR: SQL Server error: [08001][27][Microsoft][SQL Server Native Client 10.0]Client unable to establish connection $$<Configuration Manager Setup><06-21-2012 21:49:35.049-330><thread=2064 (0x810)>
*** [08001][0][Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. $$<Configuration Manager Setup><06-21-2012 21:49:35.049-330><thread=2064 (0x810)>
ERROR: SQL Server error: [08001][0][Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. $$<Configuration Manager Setup><06-21-2012 21:49:35.049-330><thread=2064 (0x810)>
*** Failed to connect to the SQL Server. $$<Configuration Manager Setup><06-21-2012 21:49:35.049-330><thread=2064 (0x810)>
INFO: SQL Connection failed. Connection: SQLSERVER2008.contoso.COM MASTER, Type: Secure $$<Configuration Manager Setup><06-21-2012 21:49:35.049-330><thread=2064 (0x810)>
ERROR: SQL Connection failed. Connection: SQLSERVER2008.contoso.COM MASTER, Type: Secure $$<Configuration Manager Setup><06-21-2012 21:49:38.065-330><thread=2064 (0x810)
ERROR: Failed to connect to SQL Server.~ $$<Configuration Manager Setup><06-21-2012 21:49:38.065-330><thread=2064 (0x810)> I would really appreciate if anyone can throw somelight on it.- Moved by Stan White [MSFT]Microsoft employee Friday, June 22, 2012 4:53 PM (From:Configuration Manager 2012 - General)
Thursday, June 21, 2012 4:31 PM
Answers
-
SQL server is it on a remote machine? If so, make sure that :
1# There is no firewall that blocks the connection.
2# Your SQL instance uses static port TCP/1433 http://msdn.microsoft.com/en-us/library/ms177440
3# The CM computer account is in the local admins group on the SQL computer.
Bechir Gharbi | My blog: @myITforum.com | Twitter: @Bechir_Gharbi | Linkedin: Bechir Gharbi | Time zone: GMT + 1
- Edited by Bechir Gharbi Friday, June 22, 2012 1:36 PM
- Marked as answer by Robert Marshall - MVPMVP Thursday, November 22, 2012 2:40 PM
Friday, June 22, 2012 1:35 PM
All replies
-
You need Server2008 R2 SP1 CU6
Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund
Thursday, June 21, 2012 4:46 PM -
Well Sorry Kent, my bad... I am actually using SQL Server 2008 ENterprise edition with SP3 CU5...!!!
Friday, June 22, 2012 3:43 AM -
That version should be fine according to http://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigSQLDBconfig
Torsten Meringer | http://www.mssccmfaq.de
Friday, June 22, 2012 7:09 AM -
SQL server is it on a remote machine? If so, make sure that :
1# There is no firewall that blocks the connection.
2# Your SQL instance uses static port TCP/1433 http://msdn.microsoft.com/en-us/library/ms177440
3# The CM computer account is in the local admins group on the SQL computer.
Bechir Gharbi | My blog: @myITforum.com | Twitter: @Bechir_Gharbi | Linkedin: Bechir Gharbi | Time zone: GMT + 1
- Edited by Bechir Gharbi Friday, June 22, 2012 1:36 PM
- Marked as answer by Robert Marshall - MVPMVP Thursday, November 22, 2012 2:40 PM
Friday, June 22, 2012 1:35 PM -
You should check registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client
SQL Server Native client doesn't write values (who knows the reason?).
Quick solution is to export this key from working pc.
Friday, March 23, 2018 5:31 AM