SCCM installation fails with 'Could not connect or execute SQL query'
When installing SCCM (SP2) and connecting to a remote SQL 2008 R2 (EE), you can receive an error: ‘Could not connect or execute SQL query’
This happens because of the installation of SQL 2008, which disables the SQL Server Browser service on the SQL server. Reset the server to Automatic and start the service.
After that you have to run the following command on the SCCM server: setspn -A MSSQLSvc/<FQDN of SQL Server> <DomainUser Name>.
Then as final step we must enable the Named Pipes and TCP/IP protocols in the SQL Server Configuration Manager. Open the SQL Server Configuration Manager, go to the SQL Network Configuration, Protocols for MSSQLSERVER and enable the Named Pipes and TCP/IP protocols, restart the SQL Server service and voila.
Daniel Nikolic
Is interested in everything connected to technology. Has a passion for cloud, virtualization and software development. Always finds appropriate IT solutions for customers that match their needs strategically, technically and financially.
Core qualities
Quick thinker, result driven, ambitious, customer-friendly, enthusiastic
Hobbies
Running, listening to music, good food and doing fun things with family
Job description
CTO PepperByte, LoadGen, and BlueParq