Problem:

Credentials to connect to MS SQL Server seems to be correct, but connection is refused

Solution:

ET-Connector needds to connect to MS SQL Server via TCP/IP which is disabled by default.
Click Start -> Programs -> SQL Server xxxx -> Configuration Tools -> SQL Server confiuration utility

Enable TCP/IP on all services and check, that the port is correct (default: 1433).

  • Check, if port 1433 (or other) is set and NOT empty
  • Check, if TCP/IP is listening by telnet to host:port. If not restart sql server service
  • Check, if telnet to host:port works, if not check, if there is a firewall in between