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 |
|
travisrail
Starting Member
2 Posts |
 Posted - 2007-05-07 : 11:15:18
|
| I have these really strange issues with my MSSQL instance. Every 5 or 6 days the machine that is running MSSQL will suddenly be unable to make any outgoing TCP/IP connections. If I open up a web browser I can't connect to any website, I can't telnet to any locations using either DNS names or IP addresses, and I lose all my linked servers. Clients can still connect to the MSSQL instance but no outbound connection can be initiated. I know this is an SQL issue because once I restart the MSSQL service then everything works as expected. Any ideas? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-07 : 13:03:27
|
| Did you see any related message in sql server log and windows event logs? May setup a network trace to find details. |
 |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2007-05-08 : 02:18:33
|
| Maybe some routing issue on your sql box? looks like a network issue since you cannot even go out with a web browser ot telnet.does pinging work? |
|
|
|
travisrail
Starting Member
2 Posts |
Posted - 2007-05-08 : 08:56:07
|
| Yes, pinging workes. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-08 : 10:43:15
|
| How about sql port? Opened on your network both directions? |
|
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2007-05-08 : 21:34:11
|
| Since it works for a few days then stop working, i guess the sql port is open, otherwise it won't work at all.How about look into the error log? is there anything shown around those time when it stop working? Since you can connect from outside without any issue and only can get out from that box, there must be a setting somewhere that got changed (somewhere in windows) since nothing can connect, not just SQL. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-09 : 11:37:29
|
| Someone may reconfig firewall. |
|
|
|
|
|
|
MSSQL Server won't do outgoing connections.