Force the TCP/IP protocol in connection string

Question

I have a database driven website written in asp.net. I'd like to modify the connection string to force protocol TCP. Please advise.

<add name="TESTConnectionString" 
     connectionString="Data Source=SERVER201;Initial Catalog=DB201;Persist Security Info=True;User ID=201User;Password=123!@#"
     providerName="System.Data.SqlClient" />

Answer 1

You can use server=tcp:hostname in your connection string to achieve this.

For more details, see How to use the server name parameter in a connection string to specify the client network library