MSDE 2000

I downloaded MSDE from microsoft. When I click on Setup.exe I get this message:-

A SA password is required for security reasons. Use SAPWD switch to supply the same.

What does this mean and how can I sort it out?

Many thanks

Jim::I downloaded MSDE from microsoft. When I click on Setup.exe I get this message:-

lets see.

::A SA password is required for security reasons.

You need to provide a password for the user SA in the database. The SA user is the Administrator of the database server.

::Use SAPWD switch to supply the same.

You need to speficy this password using - a command line parameter, called a switch.|||How do I do that?

Cheers

Jim|||Look at the bottom of this page...

http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1|||just run setup.exe SAPWD="passwd" in the cmd line

MSDE - Installation Problems

I am attempting to install MSDE 2000A on a new PC using
command prompt.
My command prompt line is as follows:
C:\MSDERelA:\ setup SAPWD = "test" INSTANCENAME = "DBASE1"
When I hit enter, a "Windows Installer" window appears.
I have installed entreprise manager on the PC and tried
registering DBASE1 but I am told the Server does not exist
or access denied.
Please help!
Wes
I found that when I try and register it it fails, then I go into the
properties and simply click OK again and it starts and connects to the
instance, go figure!
"Wes" <wharrison@.adcbarcode.com> wrote in message
news:0bac01c4cb11$550833e0$a501280a@.phx.gbl...
> OK,
> I have solved the setup problem (simple spacing issue with
> command prompt).
> I have now successfully installed MSDE.
> However I cannot register the server using entreprise
> manager?
> Can anyone explain to me how to register the server for
> use in entreprise manager?
> thanks in advance,
> Wes

MSDE

I'm trying to install MSDE so I can use MSQL with web matrix. On trying the install I'm getting a message about using SAPWD switch. I've got no idea what that's about, but obviously need to do something somewhere!

I'm running WINXP PRO

ThankxHi, it means that you need to set up a password for the sa account when installing MSDE. Read this:
http://msdn.microsoft.com/library/en-us/distsql/distsql_84xl.asp?frame=true|||how can you tell if you have msde installed or not?|||It will install itself in the c:\program files folder as Microsoft SQL Server|||Follow the instruction in the readme.ntml file. I believe it's section 3.8. Careful when typing the installation string it can be tricky. No spaces between the "="|||Thankx.

I entered the following and ran it. The installation started

C:\sql2ksp3\MSDE\setup SECURITYMODE=SQL SAPWD=my password

After the install ran I got a message saying that : "setup failed to configure the server. Reger to the server error and setup logs"

any clues?|||What do the error logs look like - can you try installing a named instance of msde - your command prompt should look as follows

setup SAPWD="AStrongSAPwd" SECURITYMODE=SQL INSTANCENAME=MyInstance

-Kashif|||I don't know where to access the error logs!

I tried the command that you suggested, I get the message: Please go to the Control Panel to install and configure system components

Thanks|||try this

setup SAPWD="AStrongSAPwd" SECURITYMODE=SQL /l* install.log

to get the logs.

-Kashif|||Kashif, thanks a lot, the following got it all going, my ASP.net apps are all working fine!

setup SAPWD= mypassword SECURITYMODE=SQL INSTANCENAME=MyInstance|||2003-09-02 16:41:40.29 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)

2003-09-02 16:41:40.29 server Copyright (C) 1988-2002 Microsoft Corporation.
2003-09-02 16:41:40.29 server All rights reserved.
2003-09-02 16:41:40.29 server Server Process ID is 164.
2003-09-02 16:41:40.29 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2003-09-02 16:41:40.30 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2003-09-02 16:41:40.40 server SQL Server configured for thread mode processing.
2003-09-02 16:41:40.40 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2003-09-02 16:41:40.47 spid3 Warning ******************
2003-09-02 16:41:40.47 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2003-09-02 16:41:40.48 spid3 Starting up database 'master'.
2003-09-02 16:41:40.67 server Using 'SSNETLIB.DLL' version '8.0.766'.
2003-09-02 16:41:40.67 spid5 Starting up database 'model'.
2003-09-02 16:41:40.72 spid3 Server name is 'IANO-SMXPDT'.
2003-09-02 16:41:40.72 spid3 Skipping startup of clean database id 5
2003-09-02 16:41:40.73 spid3 Skipping startup of clean database id 6
2003-09-02 16:41:40.73 spid3 Starting up database 'msdb'.
2003-09-02 16:41:40.76 server SQL server listening on Shared Memory.
2003-09-02 16:41:40.76 server SQL Server is ready for client connections
2003-09-02 16:41:40.83 spid5 Clearing tempdb database.
2003-09-02 16:41:41.20 spid5 Starting up database 'tempdb'.
2003-09-02 16:41:41.27 spid3 Recovery complete.
2003-09-02 16:41:41.27 spid3 SQL global counter collection task is created.
2003-09-02 16:41:41.29 spid3 Warning: override, autoexec procedures skipped.
2003-09-02 16:43:45.56 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.

What do I need to do to make this work?|||Are you having problems connecting to msde - what is the error that you see? The log file looks fine. Also can you check the version of ssnetlib.dll and post it here.

-Kashif|||Thanks for getting back to me.

Is this it ?
2000.80.766.0

I did a search and got SSnetlib.dll.CC1A8C58_27D1_4D38_BF11_C0A5CCB90616
It did not allow me to right click for properties so I copied it to a Temp directory
Where I go the above version.

Question:
At the end of the posted log file where it says
2003-09-03 09:54:23.12 spid5 Clearing tempdb database.
2003-09-03 09:54:23.51 spid5 Starting up database 'tempdb'.
2003-09-03 09:54:23.61 spid3 Recovery complete.
2003-09-03 09:54:23.61 spid3 SQL global counter collection task is created.
2003-09-03 09:54:23.64 spid3 Warning: override, autoexec procedures skipped.
2003-09-03 09:56:28.14 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.

Doesn't that 'stop' request mean that I have some service that needs starting or something?

- IanO -|||I forgot to post this. It may help you"
cnfgsvr.out

###############################################################################

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

An error occurred while attempting to start the service (1460)

SQL Server configuration failed.

###############################################################################|||Hasn't this gone on long enough?

How about disclosing the checks that the MSDE installer make and tell us what we have to do to our systems so it will pass the checks?

I and I suspect many others are beyond "just try this" suggestions.

I am appealing to the staff people who KNOW how the MSDE install script is written.
It is an obsurd waste of time and energy on this item and it delays getting into the purpose of this site - Allowing developers to get some experience building some .Net web applications.

So what say you?
Tell us how it works so we can move on?
Please include what service must be running etc.

IanOwm