Connection Microsoft SQL Server over TCP/IP

You must enable TCP/IP connection of Microsoft SQL Server, so you can connect it to from TeamSQL. It’s required.

Please check this out to enable TCP/IP Connection of Microsoft SQL Server : https://technet.microsoft.com/en-us/library/hh231672(v=sql.110).aspx

Checks these first:

  • Start the SQL SERVER BROWSER Service in Windows services if it’s not already started. See: https://technet.microsoft.com/en-us/library/ms165734(v=sql.90).aspx
  • Host name cannot be “.” (dot) SQL Server Management Studio users mostly use “.” (dot) to connect localhost. Use “localhost” instead of “.”
  • Wrong host name: .\MSSQLSERVER or .
  • Correct host name can be like: localhost, localhost\MSSQLSERVER, myserver, 192.168.10.10, 192.168.10.11\MSSQLSERVER16
  • Domain name must be upper case. If you don’t now your domain name or if you don’t have one, you still need to enter a value – upper cased.

 

 

Examples;

Without instance name

 

With instance name