all groups > sql server msde > october 2005 >
You're in the

sql server msde

group:

Installing 2nd instance of MSDE



Installing 2nd instance of MSDE Ken
10/27/2005 11:46:15 AM
sql server msde: I am trying to install WSUS on a Windows 2000 server that already has MSDE
installed for Backup Exec.

Unfortunately the WSUS installation returns the following error: "- a
database server could not be detected"

I believe WSUS is looking for an instance called "WSUS".

How do I install a 2nd instance of MSDE on a Windows 2000 server (Child
Instance????) without impacting
my default instance for Backup Exec? Thanks!!!!!!
Re: Installing 2nd instance of MSDE Ken
10/28/2005 9:56:04 AM
Thanks for your help Andrea!!!! WSUS was installed!!!

Ken

[quoted text, click to view]
Re: Installing 2nd instance of MSDE Andrea Montanari
10/28/2005 12:45:53 PM
hi Ken,
[quoted text, click to view]

you can install up to 16 (theorical) SQL Server/MSDE instance per machine...
only one of them can be the default instance, where all the others have to
be named instance..
to install a named instance you have to provide the
INSTANCENAME=WSUS
parameter to the setup.exe boostrap installer
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_84xl.asp)
, that's to say something like
c:\...\>setup.exe INSTANCENAME=WSUS SECURITYMODE=SQL SAPWD=some_pwd
DISABLENETWORKPROTOCOLS=0 /L*v "c:\msdelog.txt"
please see the referenced page for all parameter synopsis..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

AddThis Social Bookmark Button