Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Zyxu
Starting Member
1 Post |
 Posted - 2009-04-01 : 05:09:15
|
| When I connect to the SQL Server 2008 remotely it only works once, after that the server hangs. The service cannot be stopped or restarted and when trying to connect again it gives a 'Timeout' error.The server has TCP/IP connections enabled. The default port is set to 1433 and I cleared the 0 from the dynamic ports. I enabled the 127.0.0.1 IP and the public IP and set the 1433 IP to them. Named pipes and the other protocol (Shared Memory or something) is disabled.I am connecting from the remote machine using the 'sa' user and a strong password. The server is set to accept both authentication modes.Connecting for the first time from the remote machine works perfect. Queries work and data can be retrieved from the databases. After disconnecting and trying to connect again it gives a timeout error. This error is generated because the SQL Server is hanged somewhere. At this point it is impossible to Stop or Restart the SQL Server service from the service machine. The only solution is to restart the computer. However, connecting to the server locally from SQL Management Studio still works.I think it has something to do with going into an infinite loop somewhere, or it doesn't drop the connection on the 1433 port after disconnecting from the remote machine and it still waits for input from it. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-04-01 : 05:40:50
|
| What version are you using? Have you applied any of the CU's/ CU3 is the latest available and may well fix this issue. If you are not sure, run select @@version and post it here. |
 |
|
|
|
|
|
SQL Server 2008 remote connection only works once