After install and setup SQL server 2005 on Windows 2003 R2 server.
We setup the Windows Firewall giving access to the External and Internal Port 1099 and 8080.
We are able to remotely access to database using ODBC but when tried to create a new connection in Servoy Developer by using mssql_freetds with the following setup
Database Server URL: jdbc:jtds:sqlserver://171.60.60.175/dev
Here is more info about the SQL Server 2005 connection setup:
I disabled the Windows 2003 R2 firewall. But that didn not help.
In SQL server 2005 for Remote connections:
Enabled Local and Remote connections: Using both TCP/IP and Named Pipes
In TCP/IP Prosperities:
IP Addresses:
IP1: Active: Yes
Enabled: Yes
IP address: the server IP address Example 192.168.0.1
TCP Dynamic port: 0
TCP Port: 1433
IP2: Active: Yes
Enabled: Yes
IP address: the server IP address Example 192.168.0.1
TCP Dynamic port: 0
TCP Port: 1433
IP3: Active: Yes
Enabled: Yes
IP address: the server IP address Example 192.168.0.1
TCP Dynamic port: 0
TCP Port:
That’s very strange. I use MS SQL without problems. I don’t really know what to tell you!? The machine you are connecting from does get an ODBC connection? Can you connect locally on that server from Servoy?
The Windows Server 2003 R2 and SQL server 2005 are fresh installed.
Yes, I am trying to connect locally on that server from Servoy.
The ODBC works fine.
Is your SQL server 2005? If yes, do you have the same TCP/IP setting like ours?
It is becoming very frustrating for me.
I am wondering if anyone else out there having the same problem.
in MS SQL Server2005 /properties/connections: Allow remote connections to this server. Is checked.
I ended up uninstalling the entire SQL 2005 server and tools and reinstall and configure it again, but still getting the same error.
The jdbc:jtds:sqlserver://171.60.60.175/dev:1433;user=sa;password=…
does not work in Servoy DB connection setup.
Telnet to 1433 does not work, but I’m able to connect via ODBC to Port: 1433.
Check if the TCP/IP is enabled in the SQL Server 2005 Configuration Manager (right click on server) .
Search for protocols and check if TCP/IP is enabled.
By default it is disabled. In that case make it enabled.