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.
~~~~~~~~~~~~~~~~~~~~~~~~~~
" 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.
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 ?
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
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
"Setup failed to configure the server. Refer to thr server error log and setup error logs for more information."
Thanks
Vikram
setup SAPWD="mysapassword" INSTANCENAME="Company" SECURITYMODE=SQL DISABLENETWORKPROTOCOLS