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 |
|
logicwonder
Starting Member
3 Posts |
 Posted - 2009-02-01 : 05:22:39
|
I use VS2005 on client system (Windows Vista business) through which I can communicate with the database on the SQL server 2000 remote server (Windows XP SP2). Problem 1: This setup works only when I turn off windows firewall on the remote machine. I tried adding ports 1433 (tcp) and 1434 (tcp and udp) to exception list in the remote machine but then the connection fails.Problem 2: When I send my client machine to sleep or hibernate, and after when I start, connection fails and I have to restart the system to get the connection again.Please help me in resolving these problems. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2009-02-01 : 06:49:02
|
| Could you check to see if you have TCP\IP enabled in your protocol list ?Jack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
logicwonder
Starting Member
3 Posts |
Posted - 2009-02-02 : 08:35:28
|
| Ya TCP/IP is enabled and the server is accessible without the firewall. |
|
|
|
|
|
|
SQL server 2000 database on a remote machine