new MSDE install fails with "instance name specified is invalid"

I am trying to put SQL Server 2000 and MSDE on same local machine. I install
ed 2000 Developer (from VS Tools for Office)using "typical" install level, u
sing the LocalSystem Account, so no password required. When I run C:\sql2ksp
3\MSDE\setup.exe (generated
by Office 2003 disk), the first thing that happens is dialog box that says "
instance name specified is invalid" and the setup is cancelled. When I tried
to do the MSDE install before the 2000, I got a "Strong SA password is requ
ired - use SAPWD switch to
supply the same", so I installed the 2000 and then came back to try MSDE, if
only because I couldn't figure out how to get Online Books going to find ou
t about how to supply SAPWD. There is no other instance of 2000, and none of
MSDE, on the machine. I t
hought the 2000 instance was unnamed. (?)
I am an almost complete rookie about SQL Server. Any help on instance name w
ould be appreciated, or the SAPWD which may be waiting for me. Thanks !hi Bob,
"Bob P." <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:111B62D3-B753-4A78-88BD-7309173DFE4F@.microsoft.com...
> I am trying to put SQL Server 2000 and MSDE on same local machine. I
installed 2000
> Developer (from VS Tools for Office)using "typical" install level, using
the LocalSystem
>Account, so no password required. When I run C:\sql2ksp3\MSDE\setup.exe
(generated by
>Office 2003 disk), the first thing that happens is dialog box that says
"instance name
>specified is invalid" and the setup is cancelled. When I tried to do the
MSDE install before
>the 2000, I got a "Strong SA password is required - use SAPWD switch to
supply the
>same", so I installed the 2000 and then came back to try MSDE, if only
because I couldn't
>figure out how to get Online Books going to find out about how to supply
SAPWD. There is
>no other instance of 2000, and none of MSDE, on the machine. I thought the
2000 instance
>was unnamed. (?)
> I am an almost complete rookie about SQL Server. Any help on instance name
would be
> appreciated, or the SAPWD which may be waiting for me. Thanks !
the first SQL Server instance you installed hase become the default instance
becouse you did not provide instance name...
in order to install other SQL Server and/or MSDE instancese, they must be
"named" instances...
please see
http://msdn.microsoft.com/library/d...
4xl.asp
for further info about all parameters accepted by the setup.exe installer
bootstrap of MSDE...
you can download Books On Line for free from
http://www.microsoft.com/sql/techin.../2000/books.asp
hth
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.6.0 - DbaMgr ver 0.52.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply|||See the sp3 readme for the valid options for setup.
814130 INF: How to Secure Network Connectivity for SQL Server 2000 Local
http://support.microsoft.com/?id=814130
829925 Additions to the SQL Server 2000 Desktop Engine (MSDE) Release A
http://support.microsoft.com/?id=829925
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.