RE: Checking Number of MSDE Instances

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bill Cheng (billchng_at_online.microsoft.com)
Date: 08/11/04 

Date: Wed, 11 Aug 2004 13:19:49 GMT

Hi Jeff,

You may check the following registry keys.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
InstalledInstances

The format of the value is
<instance1 name><space><instace2 name>...

Bill Cheng
Microsoft Online Partner Support
Get Secure! – www.microsoft.com/security
This posting is provided “as is” with no warranties and confers no rights.
--------------------
| From: "Jeff" <jeff_nospam@eNetPortals.com>
| Newsgroups: microsoft.public.sqlserver.setup
| Subject: Checking Number of MSDE Instances
| Lines: 15
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| Message-ID: <5tdSc.20313$Jp6.19977@newsread3.news.atl.earthlink.net>
| Date: Wed, 11 Aug 2004 00:09:37 GMT
| NNTP-Posting-Host: 68.164.6.251
| X-Complaints-To: abuse@earthlink.net
| X-Trace: newsread3.news.atl.earthlink.net 1092182977 68.164.6.251 (Tue,
10 Aug 2004 17:09:37 PDT)
| NNTP-Posting-Date: Tue, 10 Aug 2004 17:09:37 PDT
| Organization: EarthLink Inc. -- http://www.EarthLink.net
| Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!w
ns13feed!worldnet.att.net!199.45.49.37!cyclone1.gnilink.net!gnilink.net!bigf
eed2.bellsouth.net!news.bellsouth.net!elnk-atl-nf1!newsfeed.earthlink.net!st
amper.news.atl.earthlink.net!newsread3.news.atl.earthlink.net.POSTED!ed114ae
b!not-for-mail
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.setup:65895
| X-Tomcat-NG: microsoft.public.sqlserver.setup
|
| Hi -
|
| I'm creating an installation program that will install a VB.NET program
and
| and instance of MSDE on an unknown desktop (commercial application). The
| install will include the MSDE redistributable files (and it will launch
the
| MSDE Setup.exe to install MSDE).
|
| MSDE allows a user to run up to 16 instances (15 named) on one machine.
How
| can my install program determine the number of installed MSDE instances?
|
| Thanks for your help.
|
| - Jeff
|
|
|

Relevant Pages

  • Critical Alert Update - W32.Slammer
    ... PSS Security Response Team Alert - Update: ... SP2, and Microsoft SQL Desktop Engine Version (MSDE) 2000 RTM, Microsoft SQL ... and all applications that install Microsoft SQL Desktop ...
    (microsoft.public.sqlserver.security)
  • Critical Alert Update - W32.Slammer
    ... PSS Security Response Team Alert - Update: ... SP2, and Microsoft SQL Desktop Engine Version (MSDE) 2000 RTM, Microsoft SQL ... and all applications that install Microsoft SQL Desktop ...
    (microsoft.public.security)
  • RE: MSDE contained in...
    ... MSDE "comes available" and "optional" with all these programs. ... most cases it is not part of the normal install, ... AD&L solution from Microsoft Visio Enterprise Network Tools 2002 ... Microsoft Project Central (a Microsoft Project 2000 companion product) ...
    (Incidents)
  • Re: MSDE contained in... (MS Office ? really ?)
    ... >products as Microsoft Office 2000/XP, Microsoft Visio ... MS Office 2000 has an installer for MSDE in the SQL dir of Disk1 ... During install, you can choose not to install MSDE if you will not be ...
    (Incidents)
  • Re: Checking Number of MSDE Instances
    ... Microsoft Online Partner Support ... | Subject: Re: Checking Number of MSDE Instances ... |> | I'm creating an installation program that will install a VB.NET ...
    (microsoft.public.sqlserver.setup)