MS SQL Server - Delay in Opening Server Connection - SQL Server Import and Export Wizard

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Delay in Opening Server Connection - SQL Server Import and Export Wizard

wrburgess@gmail.com

2006-03-10, 11:23 am

I have a laptop running SQL Server 2005 and a desktop running SQL
Server 2005. I need to use DTS to copy tables from the laptop database
to the desktop database.

I have tried numerous ways to establish a connection, but nothing is
working. This is the error I get (through the SQL Server Import and
Export Wizard) every time I try to choose a database for the source:

Could not retrieve table list

Additional information:

Unable to complete login process due to delay in opening server
connection (Microsoft SQL Native Client)

What settings do I need to set to make this happen?

Here's some more info:
Both machines run Windows XP
Both machines have all the SQL Server options 'Allowed' through the
Windows Firewall
Both machines have File & Printer Sharing 'Allowed' through the Windows
Firewall
Both databases have Remote Connections allowed

Sponsored Links