i'm trying to connect to a MS SQL Server 2000, and its giving this error: "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket". The port number is 1433 and the settings look fine as well. when i ping it or telneting it i can talk to it but when trying out my code it gives me the above error. whats funny enough is i have another SQL Server that i can connect to which means my code is fine but when i put in the details of the other server is doesnt works, what could be the problem here, is it with the server box or maybe authentication
Joined: Jan 26, 2002
Do u created a new instance of SQL server and trying to connect?.