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