March 10, 2006 at 9:57 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
March 13, 2006 at 11:26 am
Are you connecting via TCP or named pipes?
March 13, 2006 at 11:51 am
The problem has been found. There were not enough remote connections enabled on the server. Thanks for asking about the problem, though.
March 13, 2006 at 12:06 pm
Thanks for posting the solution.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply