Wednesday, March 7, 2012

Enabling TCP/IP protocol in SQL Server 6.5

I am using SQL Server 6.5. By default TCP/IP protocol is not enabled (1433 port is not opened by the server). How can I enable this so that I can use a JDBC driver to connect to it.

In SQL Server 2000, the "SQL Server Network Utility" helps us to enable the TCP/IP protocol. But not able to figure our how/where this can be done in 6.5.

Thanks for any helpGoto start --> programs --> MSSQL SErver 6.5 --> SQL Setup and from there you can add the network library for TCP/IP and then after you must restart SQL services to take affect of new settings.

No comments:

Post a Comment