September 25, 2008 at 9:45 am
Hello:
When I tried to connect to a SQL Server 2008 instance using MS' 2005 JDBC driver, I get the following error:
An error occurred while performing the operation:
An error occurred while establishing the connection:
Type: com.microsoft.sqlserver.jdbc.SQLServerException Error Code: 0 SQL State: 08S01
Message:
The TCP/IP connection to the host localhost, port 1433 has failed. Error: Connection refused: connect. Please verify the connection properties and check that a SQL Server instance is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.
Can somebody help me resolve this problem? Also, how do I find out that it is port 1433 on my machine. I snooped around and cannot verify that my instance is running on that port.
Venki
September 25, 2008 at 9:57 am
And, I have the port added to and enabled in my Windows Firewall Exception list.
Venki
September 25, 2008 at 11:20 am
I had to erase the entry for TCP Dynamic Ports under IPAll section, and specify 1433 for the TCP Port.
Once I restarted the server, I was able to connect.
Venki
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply