Problem accessing Ms SQL server 2000 via Servoy Server confi

Classic Servoy
1

Hi all,

We setup a new Ms 2003 server that is running Ms SQL server 2000 database.
We are having problem to access to our Ms SQL server via Servoy Server Config
Here is the error:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

However, on the same Servoy server I’m able to login to different MS SQL server by using Servoy Server Config.
I tried to establish the connection using Servoy Server Config from different server, still get the above error.
Note: I was able to use ODBC establishing the connection to Ms SQL server successfully.

Please advise.

Thanks,

Abrahim

2

Do you have TCP/IP connections enabled on that server?

To check the enabled protocols for a server, follow these steps:
In SQL Server 2000, start the SQL Server Network Utility (svrnetcn.exe).
On the General tab, select the instance of Microsoft SQL Server on which to load an installed server network library.
Make sure that TCP/IP appears in the Enabled Protocols list.

3

Jan,

I just find out that to fix this problem we need to installing SP3 on Ms SQL server 2K.

Thanks,

Abrahim