Re: Leaving Instance name blank does the trick buy why?

From: Dan (surfonbuy_at_hotmail.com)
Date: 06/16/04


Date: Wed, 16 Jun 2004 00:04:08 GMT


"Craig" <cbetteridge@excite.com> wrote in message
news:9e2aed11.0406151542.294cb8f6@posting.google.com...
> So I've been trying to write a little application that uses MSDE 2000.
>
> Everytime I did the install the service manager wouldn't come up
> without having to enter the server and instance and then even though I
> checked the box to auto start ... it never would come up.
>
> I checked services and every thing was cool but it just wouldn't come
> up.
>
>
> I started thinking about the lack of a local instance and decided to
> do an install leaving the 'instance name' blank.
>
> It worked!!!
>
> Everything is perfect but why?
>
> My only guess is that I needed a (local) install be for a named
> instance. Does this make any sense.
>
> Thanks,
>
> cb

Craig,

It's been my experience that the "Service Manager" does not display locally
installed instance names in it's pull down combobox. However if you install
MSDE without specifing an instance name, the "default instance" is installed
and does appear in the Service Manager. I think what you've observed is
expected behaviour.

Dan



Relevant Pages

  • Re: MSDE 2000 not running in Win 98
    ... > Instead of the .bat file, check the "Auto-Start service when OS starts" box in> the SQL service manager. ... > The SQL service manager gets installed as part of the normal MSDE install, so> you should have it, and I think it gets put into startup/ even if the server> doesn't. ... I asked the client to do the same and he doesn't see the MS SQL> Server running. ...
    (microsoft.public.sqlserver.msde)
  • Re: Leaving Instance name blank does the trick buy why?
    ... Interesting comment, Dan. ... I have the same problem except the service manager cannot find the local instance at all even when I type it in the combo box. ... >> do an install leaving the 'instance name' blank. ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL 2000 installation on SBS2003
    ... Service manager show up. ... Where can I find/ how can I resurrect the SQL ... it may not be the SQL setup at all.. ... > ok and the SQL setup will continue, once the setup completes, then install ...
    (microsoft.public.windows.server.sbs)
  • Leaving Instance name blank does the trick buy why?
    ... Everytime I did the install the service manager wouldn't come up ... I checked services and every thing was cool but it just wouldn't come ... I started thinking about the lack of a local instance and decided to ...
    (microsoft.public.sqlserver.msde)
  • Re: MSDE automatic install
    ... Thanks for pointing out that the Service Manager was installed on the ... rather have it running at startup than start it in my app. ... > The install already took care of installing the SQL Manager at Startup ...
    (microsoft.public.sqlserver.setup)