Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Timpu
Starting Member
2 Posts |
 Posted - 2009-12-05 : 18:45:43
|
| Hi,I'm trying to move a 2008 database from one SQL server to another. One machine is running XP, the other Windows 7 Home.When I try to use import/export wizard from one machine to the other, but I get this error. >>Failed to connect to server SQL01.>>A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.Both of these machines reside on a LAN, but not on a domain. I'm using windows authentication on both servers, and I can't seem to add one computer account to the other's administrator account. I'm wondering if anyone has some advice they can give me. Thank you for your help.Tim - Newbie |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Timpu
Starting Member
2 Posts |
Posted - 2009-12-06 : 20:20:39
|
| Thank you Tara! After tripping over myself trying to get both machines logged in with the sa account, it was super easy. Thanks for taking the time to help out a newbie.Tim |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Problem with moving a 2008 database