Posted by Chris on 06/26/06 23:30

Erland Sommarskog wrote:
> Chris (chris.wisherd@kenblanchard.com) writes:
> > Don't know if there is a simple solution for this one or not. When
> > running SQL server on a machine with 2000 loaded and the complete SQL
> > package I don't have any issues. Now I'm trying to login using my XP
> > machine with MSSQL developer edition, and I can not connect to my
> > remote servers via TCP/IP. It can see the server, and it establishes a
> > connection, but I can't access my files, and the connection seems
> > incredibly slow. I have checked my firewall, and its fine. I'm just
> > wondering why my 2000 system can access it, but my XP can't. Any
> > ideas???
>
> I'm confused, can't you connect at all, or is the communication just slow?
>
> On which machine does the SQL Server you are connecting to run? Is the XP
> machine in the same domain as the SQL Server machine?
>
> What files are you unable to access? You usually don't use SQL Server
> to access files.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx


I can connect to the server, but it is slow. But I can't access
information such as the databases. It comes up with no items. I also
can't backup any of the data to a local machine. There wasn't any
issue until we loaded the 2003 Developer Edition on our XP machines.
I've loaded both service packs 3 and 4 hoping that would solve the
problem. I've checked TCP/IP setting, and the firewall.

The server I'm trying to access is a remote server running Windows
2000, with service pack 4, and it is in a different domain.

[Back to original message]