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

From: Mark Ferguson (MarkFerguson_at_discussions.microsoft.com)
Date: 06/16/04 

Date: Tue, 15 Jun 2004 20:41:01 -0700

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. See my second post for topic "Installed MSDE Rel A does not appear to work".

Not displaying the instance name may seem normal, but there must be a catch to it. I installed the instance with DisableNetworkProtocols=0 to enable network access from a peer computer. I wonder if the the Service Manager can't get thru to the SQL Server via the TCP/IP (they still communicate by TCP/IP if they are both on the one system). 

-- 
Mark Ferguson
-------------------------
"Dan" wrote:
> "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: Leaving Instance name blank does the trick buy why?
    ... > I started thinking about the lack of a local instance and decided to ... > do an install leaving the 'instance name' blank. ... It's been my experience that the "Service Manager" does not display locally ... MSDE without specifing an instance name, ...
    (microsoft.public.sqlserver.msde)
  • 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 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: 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)
  • 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)