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 |
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2007-04-24 : 15:22:36
|
Hi Guys hope someone can help with this one, I am working on SQL 2000 and having problem with logging a new server instance to be run in query analyzer let me explain, I have the default sql server and then also an instance called sqlone on the same machine for study reasons.However after loading the new instance on and then registering it in enterprise manager it appears fine on there, but I am having problem only in query analyzer the sqlone instance does not appear in the drop down menu so that I can select too work on that serverOnly reason I need this is as I am practicing adding linked servers and without the second instance being visible it won't work correctly. For other infomation the instance ok in the enterprise manager, server manager and then in the computer management in the administrative tools in the control panel.Any advice please people ThanksNeil G |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-24 : 15:25:06
|
Just type it in!YourHostName\SQLONETara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2007-04-24 : 15:36:32
|
O how stupid of me, I tried typing in SQLONE and it said it could find the server, I forgot that you needed to put the default server name first Thanks a lot for the response |
|
|
|
|
|