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
posted 11 years ago
Do u created a new instance of SQL server and trying to connect?.