# Problem accessing Ms SQL server 2000 via Servoy Server confi

**URL:** <https://forum.servoy.com/t/problem-accessing-ms-sql-server-2000-via-servoy-server-confi/2071>\
**Category:** Classic Servoy\
**Created:** [June 21, 2004, 9:25pm UTC](https://forum.servoy.com/t/problem-accessing-ms-sql-server-2000-via-servoy-server-confi/2071 "2004-06-21T21:25:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![akalehzan](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@akalehzan](https://forum.servoy.com/u/akalehzan)\
**Post date:** [June 21, 2004, 9:25pm UTC](https://forum.servoy.com/t/problem-accessing-ms-sql-server-2000-via-servoy-server-confi/2071/1 "2004-06-21T21:25:19Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Jan\_Aleman](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)\
**Post date:** [June 22, 2004, 11:34am UTC](https://forum.servoy.com/t/problem-accessing-ms-sql-server-2000-via-servoy-server-confi/2071/2 "2004-06-22T11:34:12Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![akalehzan](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@akalehzan](https://forum.servoy.com/u/akalehzan)\
**Post date:** [June 22, 2004, 3:53pm UTC](https://forum.servoy.com/t/problem-accessing-ms-sql-server-2000-via-servoy-server-confi/2071/3 "2004-06-22T15:53:32Z")

</div>

Jan,

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

Thanks,

Abrahim