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.

1 comment:

  1. Who'd rather refuse such an amazing chance? I believe that everybody who works in marketing should be eager to learn more about it. Now that the Quantitative Analysis Assignment Help are at their disposal, all students appear to be enjoying it, hopefully in the same manner that marketing professionals do. Thanks to the availability of top-notch assignment services, marketing specialists have a rare chance to develop their abilities and become authorities in their field.