MSSQL2K SP4 INSTANCES | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


HI Guys and Dolls
WHY? in enterprise manager and query analyser when trying to connect or register, to a new named instance or a server with two named instances and no default, do I only see the name of the server. I would like to know how to see all instances on my network. Yo
When you try to register for the first time with EM you have to write those names. Example: Serverinstance1, Serverinstance2. I suppose you are using the wizard in EM.
Luis Martin
Moderator All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
You can try registering the default instance which will be the servername, if you have tried that already then ensure the SQL Server services for that instance are started successfully. OSQL -L is to know about available SQL instances on the network. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.