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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-07 : 09:09:37
|
dan writes "Here's the situation:
Using the sp_detach_db I removed a database (I'll call it db1) from Server 1, copied the primary and log files to Server 2, and ran sp_attach_db on Server 2 for db1.
Please note, both files were .dat extensions.
Also, please note that Server 1 was turned off after we reattached db1 to Server 2.
Both systems are Windows NT 4.0, sp5, SQL 7 sp1.
Due to complications in the 3rd party application (IIS software) we had to go back to Server 1.
Here's my question:
I detached the database from Server 2, removed the 3rd party application, and rebooted the server. While Server 2 was rebooting, I ran the sp_attach_db on Server 1, reattaching the original files. Everything seemed to be going fine however; we seemed to be unable to connect to the server using the Enterprise Manager Console (the error was a connection failed), although the Query Analyzer worked fine. Server 2 came back up and I verified that the SQL database (db1) had been successfully removed and detached, as well as the 3rd party application software.
A few minutes later the Enterprise Manager Console started working. I noticed in the console that Server 2 was a Linked and Remote server for Server 1 however; at no time did anyone create this link. Also, Server 1 was not a linked/remote server for Server 2.
1. How did Server 2 become a linked/remote server of Server 1 on it's own?
2. Why wouldn't the Enterprise Manager Console work, yet the Query Analyzer did?
3. What will fix the problem?" |
|
|
|
|
|
|
|
Mysterious Linked/Remote Server