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 |
|
tribune
Posting Yak Master
105 Posts |
 Posted - 2003-03-03 : 19:16:46
|
| We have two sql 2000 servers here. One I recently installed as a backup, and the main machine. When I connect to the main machine, I can access it through EM or QA by IP or the computer name. However, with the new machine, I have to type in the ComputerName\InstanceName. Any ideas on how to convert this back so I can connect to the new machine like the old one? I'm worrying that this will cause further connection problems when I need to switch servers in a manual fail-over situation. Thanks :) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-03 : 20:00:13
|
| Well it sounds like for the new machine that you didn't use the default instance. Instead, you used a named instance. So, you are stuck calling it computername\instancename. If you want to get around this, just uninstall and then reinstall with the default instance. This isn't a problem, btw. You will not encounter problems with a fail-over situation just because you are using a named instance.Tara |
 |
|
|
|
|
|
SQL Server Connection/Instance question