Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL server 2000 database on a remote machine
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

3 Posts

Posted - 02/01/2009 :  05:22:39  Show Profile  Reply with Quote
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.

Edited by - logicwonder on 02/02/2009 08:45:01

Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 02/01/2009 :  06:49:02  Show Profile  Visit jackv's Homepage  Reply with Quote
Could you check to see if you have TCP\IP enabled in your protocol list ?

Jack Vamvas
Go to Top of Page

Starting Member

3 Posts

Posted - 02/02/2009 :  08:35:28  Show Profile  Reply with Quote
Ya TCP/IP is enabled and the server is accessible without the firewall.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000