I want to connect from a redhat system with PHP / freetds to SQL-Server 2008 on Windows Server 2008.
Result: Server is unavailable or does not exists
Connecting to an further SQL-Server works without any problems, so the error is located on the SQL-Server or on the Windows Server 2008
Connecting with the Management Studio: success
netstat -a: no listening task on 1433
telnet server 1433: failed
tsql -H server -p 1433 -U sa: failed "Server is unavailable or does not exists"
TCP and Named Pipes on
TCP Port 1433
[Windows Server 2008]
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.(InstanceName)\MSSQLServer\SuperSocketNetLib\TCP\IPAll) and the port is set to 1433.
So I think the SQL-Server does not listen on port 1433. So what could be the problem or what I have to connect to this sql-server over tcp 1433.
Thanks for your help.