Thursday 9 August 2012

Forcing network protocol to connect SQL server


Whenever there is a network issue or a SQL server browser issue we might need to connect SQL server in different network protocols to troubleshoot. We can change the default protocol in configuration manager but it will make the change globally for all connection connecting to the SQL instance, instead we can force the protocol for your connection alone pretty easily by appending the protocol name to the servername in SSMS, SQLCMD or any source connecting to the SQL instance like

Forcing TCP:

  

Forcing Named Pipes:-



Similarly we can force protocol while connecting through SQLCMD or through any source.

No comments:

Post a Comment