SQL Server 2005 connection issue

[Russel]

Hello,

I just installed SQL Server 2005 and i am trying to connect using DbSchema, i always get the following error:

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "connect timed out. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".


Thanks.

[donose.mihai]

Hello,

I just installed SQL Server 2005 and i am trying to connect using DbSchema, i always get the following error:

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "connect timed out. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".


Thanks.

Hi, Russel,

In the connection window you got a help button located in the bottom left, click it and it will display the help for the current connection (maybe it will help you).

Do the following:

Open Sql Service configuration manager go to Protocols for SQLEXPRESS and be sure that all the protocols are enabled.
If your server runs on the default port 1433 be sure to put manually all the TCP Dynamic Ports to 1433 and also the IP1 & IP2 to be set as Enable.
After that restart the services.Go to Sql Server 2005 Services and restart the SQL Server.

Hope it will solve your issue.

[Russel]

Hello,

I just installed SQL Server 2005 and i am trying to connect using DbSchema, i always get the following error:

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "connect timed out. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".


Thanks.

Hi, Russel,

In the connection window you got a help button located in the bottom left, click it and it will display the help for the current connection (maybe it will help you).

Do the following:

Open Sql Service configuration manager go to Protocols for SQLEXPRESS and be sure that all the protocols are enabled.
If your server runs on the default port 1433 be sure to put manually all the TCP Dynamic Ports to 1433 and also the IP1 & IP2 to be set as Enable.
After that restart the services.Go to Sql Server 2005 Services and restart the SQL Server.

Hope it will solve your issue.

Thanks!!! It worked like a charm!

[flogger123]

Quick workaround. Does this issue happens a lot to users?