Thursday, December 19, 2013 ConfigMgr: Failed to connect to the SQL Server, connection type: SMS ACCESS.

I installed ConfigMgr 2012 with SP1 in my LAB environment yesterday. The SQL 2012 server is located on a remote server and I decided to use a single site (primary site) installation of ConfigMgr. Before I started the 'splash.hta', I extended the AD schema and created the 'System Management' OU.

The ConfigMgr prerequisite checker noticed me to add the computer account of the ConfigMgr server to the local administrator group of the sql server and to change the SQL server TCP/IP port configuration to static. Ok, so I added the account and changed the TCP/IP configuration and the wizard finished the installation of ConfigMgr 2012 successful. 

Afterwards, I checked the setup log files and found the following error message entries in the HMAN.log file:

Figure 1: HMAN.log

I opened the ODBC configuration of the ConfigMgr server and noticed that the System DSN named 'SMS SQL' had a wrong configuration (as you can see on figure number 2).

Figure 2: SQL Server DSN configuration

I closed the SQL Server DSN configuration wizard and opened it again to add the missing SQL instance name into the SQL server input box. Then I chose 'Windows NT authentication' and removed the SQL instance name from the default database input box.