Developer Edition having issues connecting to server via TCP/IP

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Chris
    #1

    Developer Edition having issues connecting to server via TCP/IP

    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???

    Tags: None
    • Erland Sommarskog
      #2
      Re: Developer Edition having issues connecting to server via TCP/IP

      Chris (chris.wisherd@ kenblanchard.co m) writes:[color=blue]
      > 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???[/color]

      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@sommarsk og.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

        Comment

        • Chris
          #3
          Re: Developer Edition having issues connecting to server via TCP/IP

          Erland Sommarskog wrote:[color=blue]
          > Chris (chris.wisherd@ kenblanchard.co m) writes:[color=green]
          > > 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???[/color]
          >
          > 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@sommarsk og.se
          >
          > Books Online for SQL Server 2005 at
          > http://www.microsoft.com/technet/pro...ads/books.mspx
          > Books Online for SQL Server 2000 at
          > http://www.microsoft.com/sql/prodinf...ons/books.mspx[/color]


          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.

            Comment

            • Erland Sommarskog
              #4
              Re: Developer Edition having issues connecting to server via TCP/IP

              Chris (chris.wisherd@ kenblanchard.co m) writes:[color=blue]
              > 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.[/color]

              I realise that I should have asked what you are connecting with and
              with which credentials.

              From what you say, it sounds as it you connect with Enterprise Manager
              with integrated security, but your Windows login has not been added to
              BUILTIN\Adminis trators and on top of all databases are set to autoclose.
              When databases are set to autoclose, and you connect as a non-priv user,
              EM has to access every database to see if you are permitted, and this
              can take forever.


              --
              Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.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

                Comment

                Previous template Next
                Working...