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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2004-12-13 : 05:15:01
|
| Hi ,I have created three SQL instances on a SQL 2000 server with SP3a . I have also restored databases under these instances based on our dept . classification . So when I open my SQL Enterprise manager on the local SQL server itself , it shows me the correct list of databases under the Instances I have restored . Now I have also registered the same instances on my client workstation which is Windows 2000 professional , but when I expand the databases under each instance , it shows the same list of the databases with the same names for all the instances . Are there any such issues with SQL EM or any other settings that I need to do to resolve this ? I tried closing the EM and starting again , but it seems to be the same case. Please help .Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-13 : 14:27:40
|
| You probably need aliases setup with Client Network Utility on the client workstation. The alias would specify the port that the instance is listening. You are probably pointing to port 1433 for all of them, hence getting you to the default instance.Tara |
 |
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2004-12-13 : 21:58:57
|
| Thanks for your help Tara . The problem has been resolved. |
|
|
|
|
|
|
Register Multiple SQL instances .