- Check if tcp/ip is enabled for the server instance
- Check firewall
- Use a network tool (like Network Monitor) to catch the connection failure on tcp or ip level
- This connection string is useful in
special cases[
^], you should use the general
connection string syntax[
^]
(PS: never use SA to connect an application to the server! You are in a domain and you can add even AD groups as users to SQL server, thus
use trusted connection. )
Submit an article or tip