Share via

SQL Server Configuration Management missing protocols

Robb 0 Reputation points
2025-12-06T13:17:46.6066667+00:00

I can't connect to SQL Server using a simple UDL file but I can connect to it through SSMS. I have two nodes in the SQL Server Configuration Management which does not look right and there are no Client protocols in either of those nodes. Wouldn't those protocols would be there when installation takes place?

Screenshot 2025-12-06 050925

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments

Answer recommended by moderator

Robb 0 Reputation points
2025-12-07T01:35:29.7266667+00:00

I finally got this working after a lot of messing around. As stated very briefly in the reference below and by Erland above the Microsoft® SQL Server® 2012 Native Client is old and no longer used. The "replacement" appears to be enabling protocols in "SQL Server Client Network Utility".

Enabling protocols in "SQL Server Client Network Utility":

  1. Open a command prompt
  2. Type "cliconfg.exe"
  3. Enable: TCP/IP
  4. Enable: Nambed Pipes

Reference: https://techcommunity.microsoft.com/discussions/sql_server/missing-client-protocols/4193681

Windows 11 Pro

SQL Server 2025

SSMS 22

Umbraco 17.0.0

Was this answer helpful?

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator
    2025-12-06T17:03:33.7366667+00:00

    That node is for legacy drivers that does not ship with modern versions of SQL Server. Furthermore, those drivers were never used by SSMS.

    If you have problems with connecting to SSMS, the issue is something else. We would to see the error message from SSMS. We would also need to know if you are running SSMS on the same machine as SQL Server or on a different machine.

    Was this answer helpful?

  2. Marcin Policht 92,630 Reputation points MVP Volunteer Moderator
    2025-12-06T13:36:21.9633333+00:00

    Refer to https://learn.microsoft.com/en-us/answers/questions/1377510/sql-server-native-protocol-doesnt-exist

    If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

    hth

    Marcin

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.