a bit more info is required. Please describe your setup for us, for example is the mssql server in a dedicated machine/VM? are there two separate sql servers? Are both clients (debian 8, debian 9) on the same network or there is any nat/router in between. Is there any firewall in between? does the firewall allow connections in ports bellow 1024 with out being a root/admin? do you have white list setup on your firewall?
Hi taazz,
in the network are exists 2 SQL-Servers in VmWare ESXi,
there is no Firewall between Server and Client,
Server and Clients are in the same Network,
both Clients are running in a VmWare Workstation 10
If you SQL Server uses instance names, make sure you specify that in the connection string as well.
Hi Graeme,
the SQL-Server is standard, no instances.
Only the Name of the Server contains a "\" (HostName = "xxx\yyyyyyyyy"),
but we never had Problems with this!
thanks eikko