Default Instance of SQL Server does not show services

#1

Hello,

I have 2 instances of SQL Server 2000. On the windows Task
bar. The Default instance does not show the tringle in the
circle indicating that it is in the start/comtinue mode,
nor does it show any services. Thus, it shows that the
default instance is not connected. However, My second
instance does have these attributes. Although, in the MMC
both instances are shown running.

Thanks alot

Scott

#2

Dejan,

Thanks your suggestion resolved the issue.

Thanks again,

Scott

Quote:

-----Original Message-----
Ok, so it is not going the easy way. All right, then
let's do it the hard
way:-) Use registry editor, check the
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft
\Microsoft SQL Server key. Check the InstalledInstances
entry. Insert the
missing instance in a separate row. For the default
instance insert
MSSQLServer. Refresh services in Service manager again.
You should have it
now.

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Scott Armand" <sarmand (AT) safety-kleen (DOT) com> wrote in message
news:437a01c340ab$3b000c30$a401280a (AT) phx (DOT) gbl...
Dejan,

Yes. I have tried to refresh the list via clicking the
button. However, there are no services listed in the
Drop-
Down List.
-----Original Message-----
Have you trieed to press the "Refresh services" button
in
the Service
Manager?

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"ScottArmand" <sarmand (AT) safety-kleen (DOT) com> wrote in
message
news:045f01c34014$0994dbe0$a301280a (AT) phx (DOT) gbl...
Hello,

I have 2 instances of SQL Server 2000. On the windows
Task
bar. The Default instance does not show the tringle
in
the
circle indicating that it is in the start/comtinue
mode,
nor does it show any services. Thus, it shows that
the
default instance is not connected. However, My second
instance does have these attributes. Although, in the
MMC
both instances are shown running.

Thanks alot

Scott

.

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Default Instance of SQL Server does not show services

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup

Default Instance of SQL Server does not show services - 07-01-2003 , 04:02 PM

Re: Default Instance of SQL Server does not show services - 07-03-2003 , 10:29 AM