0

I have a ASP.NET MVC application and connects to the SQL Server running on a different server. I wish to know which is the default protocol used between the MVC app and SQL-server to exchange the data.

1
  • 1
    You can check out the MSDN pages about Network Protocols and their defaults. However your question is too broad and lacks minimal research effort and might get closed/deleted if you keep it this way...
    – kayess
    Dec 8, 2016 at 12:05

1 Answer 1

1

"By default, the default protocol for SQL Server clients is TCP/IP. If the connection cannot be made using TCP/IP, the other enabled protocols are attempted. A shared memory connection cannot be made over a network. Use SQL Server Configuration Manager to enable or disable client protocols, and to change the order in which connection attempts are made"

https://technet.microsoft.com/en-us/library/ms190204(v=sql.105).aspx

Basically you specify it in your connection string and it can fall back through negotiation with the server

1
  • Yeh, this link is useful and i was looking for such kind of information. Thanks.
    – Karan
    Dec 8, 2016 at 12:52

Not the answer you're looking for? Browse other questions tagged or ask your own question.