Link to home
Start Free TrialLog in
Avatar of tedhill
tedhill

asked on

MSDE INSTALLATION PROBLEM

I have a Windows 2000. When I tried to INSTALL the MSDE in order my Visual C# programs could deal with SQL databases, I got this message:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
" Microsoft SQL Server Desktop Engine

A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit."
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Well since I a novice both in C# programming and SQL database, I have no idea:

1) what a "strong SA password" is.

2) what a SAPWD switch is and how to set it.

I did not find any readme file specific for the  MSDE installation. The one that comes with it, it is about the installation of the SQL server.


I intend to access the SQL Server as a LOCAL USER and using WINDOWS INTEGRATED SECURITY.

This is the Connection String that I use in my web.config:

<add key="ConnectionString" value="server=(local); database=MyDatabase; trusted_connection=true" />

3) So what I should do ?

I would be grateful if you could answer these three questions. Thank you.
Avatar of Lee W, MVP
Lee W, MVP
Flag of United States of America image

Try launching setup with this command (note: change the "Mysapassword" and "Company" to something appropriate for you.

setup SAPWD="mysapassword" INSTANCENAME="Company" SECURITYMODE=SQL DISABLENETWORKPROTOCOLS
Avatar of tedhill
tedhill

ASKER

leew, I have no idea what is a "SA password". Is it the password needed to run the Windows 2000 ?

If so, I DO NOT USE ANY PASSWORD because I wanted to run my system and programs as easily as possible.

Secondly, I have no "Company". I am just learning "C#" and SQL at home.
ASKER CERTIFIED SOLUTION
Avatar of Lee W, MVP
Lee W, MVP
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tedhill

ASKER

Leew, to install the MSDE I used the Run command: D:\sql2ksp3\MSDE\setup SAPWD=mypassword

But after while it gave me this message:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Microsoft SQL Server Desktop Engine

Setup failed to configure the server. Refer to thr server error log and setup error logs for more information.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

The LOG gave me this content:



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2005-08-28 20:59:46.94 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.0 (Build 2195: Service Pack 4)

2005-08-28 20:59:47.00 server    Copyright (C) 1988-2002 Microsoft Corporation.
2005-08-28 20:59:47.00 server    All rights reserved.
2005-08-28 20:59:47.00 server    Server Process ID is 2252.
2005-08-28 20:59:47.00 server    Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2005-08-28 20:59:47.09 server    SQL Server is starting at priority class 'normal'(1 CPU detected).
2005-08-28 20:59:47.45 server    SQL Server configured for thread mode processing.
2005-08-28 20:59:47.47 server    Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2005-08-28 20:59:47.87 spid3     Warning ******************
2005-08-28 20:59:47.87 spid3     SQL Server started in single user mode. Updates allowed to system catalogs.
2005-08-28 20:59:48.13 spid3     Starting up database 'master'.
2005-08-28 20:59:50.79 server    Using 'SSNETLIB.DLL' version '8.0.766'.
2005-08-28 20:59:50.79 spid5     Starting up database 'model'.
2005-08-28 20:59:50.98 spid3     Server name is 'PEGASUS'.
2005-08-28 20:59:50.98 spid3     Skipping startup of clean database id 5
2005-08-28 20:59:51.01 spid3     Skipping startup of clean database id 6
2005-08-28 20:59:51.01 spid3     Starting up database 'msdb'.
2005-08-28 20:59:52.03 spid5     Clearing tempdb database.
2005-08-28 20:59:53.95 server    SQL server listening on Shared Memory.
2005-08-28 20:59:53.95 server    SQL Server is ready for client connections
2005-08-28 20:59:54.00 spid5     Starting up database 'tempdb'.
2005-08-28 20:59:54.75 spid3     Recovery complete.
2005-08-28 20:59:54.75 spid3     SQL global counter collection task is created.
2005-08-28 20:59:54.92 spid3     Warning: override, autoexec procedures skipped.
2005-08-28 21:01:42.63 spid3     SQL Server is terminating due to 'stop' request from Service Control Manager.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


( I wonder if it does matter if the IIS service was activated or not during the installation )


What I should do now ?
You need to put those settings in the Setup.ini file.

Bob
I am having the same error and I have set up the Ini file. I still get the error:
"Setup failed to configure the server. Refer to thr server error log and setup error logs for more information."

Thanks
Vikram