Installing 2nd instance of 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!!!!!!
hi Ken,
Ken wrote:
> 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!!!!!!
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/de...stsql_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.shtmhttp://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
|||Thanks for your help Andrea!!!! WSUS was installed!!!
Ken
"Andrea Montanari" wrote:

> hi Ken,
> Ken wrote:
> 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/de...stsql_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.shtmhttp://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
>
>
sql