Duplicate instances

On one box Enterprise Manager is indicating a second instance â' . (Windows
NT)â' , in addition to the default instance, â' (local) (Windows NT)â'. This
second instance was not installed, It just appeared. The MSSQL directory
indicates the presence of only one instance. Databases, and security
configurations are identical in structure and information between the two
instances. Has any one seen this happen? Would you recommend deleting the
â'Ghostâ' instance. Any ideas welcome. Thanks to everyone for being there to
help. SQL 2000 SP4.coenzyme wrote:
> On one box Enterprise Manager is indicating a second instance â' . (Windows
> NT)â' , in addition to the default instance, â' (local) (Windows NT)â'. This
> second instance was not installed, It just appeared. The MSSQL directory
> indicates the presence of only one instance. Databases, and security
> configurations are identical in structure and information between the two
> instances. Has any one seen this happen? Would you recommend deleting the
> â'Ghostâ' instance. Any ideas welcome. Thanks to everyone for being there to
> help. SQL 2000 SP4.
>
You can safely delete either one - registrations in EM have no effect on
the actual instances that are running.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thanks Tracy. It's a real comfort to know there's experienced people like you
who are willing to help.
"Tracy McKibben" wrote:
> coenzyme wrote:
> > On one box Enterprise Manager is indicating a second instance â' . (Windows
> > NT)â' , in addition to the default instance, â' (local) (Windows NT)â'. This
> > second instance was not installed, It just appeared. The MSSQL directory
> > indicates the presence of only one instance. Databases, and security
> > configurations are identical in structure and information between the two
> > instances. Has any one seen this happen? Would you recommend deleting the
> > â'Ghostâ' instance. Any ideas welcome. Thanks to everyone for being there to
> > help. SQL 2000 SP4.
> >
> >
> You can safely delete either one - registrations in EM have no effect on
> the actual instances that are running.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>