Question: I’ve been advised to use the prefix tcp: for a SQL Server connection, during some connection troubleshooting. Could you explain the purpose of using the tcp: prefix , such as :
Answer: The tcp: prefix will force the usage of TCP/IP transport. There are certain situations , where using the tcp: will allow a valid SQL Server connection.
When using the tcp: prefix you’re requesting to explicitly connect through TCP/IP. If the server is not listening on TCP/IP , your options are either to not use the tcp: prefix or locate and enable the tcp protocol. Use the SQL Server Configuration Manager | SQL Server Network Configuration tab for the SQL Server Instance.