SCCM Installation Failure: Unable to Connect to SQL Server

Question

Attempting to install SCCM results in the following error message:

Setup is unable to connect to SQL Server with the connection information provided. Verify the following:

The SQL Server and instance names are entered correctly 
The specified SQL Server instance is not configured to use dynamic ports 
If a firewall is enabled on the SQL Server, inbound rules exist to allow connections to the correct ports 
The account used to run Setup has permissions to connect to the specified SQL Server instance

Are there any additional suggestions to troubleshoot this issue?

Answer 1

Hi,

I found a relevant case that might help you troubleshoot your SCCM installation issue. In this case, a user was unable to connect SCCM to the SQL Server database during a fresh install. Here are some key points from their experience

SQL Server Configuration:

• They ensured that TCP/IP was enabled for the SQL Server instance.
• They set a static port for the SCCM instance, as dynamic ports were causing issues.

Firewall and Network:

• They verified that the firewall allowed connections on the necessary ports.
• They tested the connection using SQL Server Management Studio (SSMS) from the SCCM server to ensure there were no network issues.

Permissions:

• They confirmed that the account running the SCCM setup had the necessary permissions to connect to the SQL Server instance.

SQL Server Browser Service:

• They made sure the SQL Server Browser service was running, which is essential for named instances. You can find more details and discussions on this case here

I hope this helps! Let me know if you need further assistance or if there's anything specific, you'd like to explore.