BUG: BOL Incorrect on SAPASSWORD and USEDEFAULTSAPWD Options for SQL Server 2000 Desktop Engine Installation

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q285103

BUG #: 234939 (SHILOH_BUGS)

Expand all | Collapse all

SYMPTOMS

The "Merging the Desktop Engine into Windows Installer" topic in Microsoft SQL Server 2000 Books Online incorrectly documents that you can use the SAPASSWORD and USEDEFAULTSAPWD parameters when you install the SQL Server 2000 Desktop Engine by using Microsoft Windows Installer Merge modules.

Back to the top

CAUSE

The SQL Server 2000 Books Online documentation is incorrect. The SAPASSWORD and USEDEFAULTSAPWD options are not available when you use the products mentioned in the "Symptoms" section.

Back to the top

WORKAROUND

The SAPASSWORD and USEDEFAULTSAPWD options are unavailable due to security purposes. If a system administrator (sa) password needs to modified, you should be able to make the modification after the installation completes successfully.

Back to the top

STATUS

Microsoft has confirmed this to be a problem in SQL Server 2000 Books Online.

Back to the top

MORE INFORMATION

According to SQL Server 2000 Books Online, the SAPASSWORD and USEDEFAULTSAPWD options have the following functionality:

Collapse this tableExpand this table

Option	Description
SAPASSWORD	Can be used to modify the "sa" password.
USEDEFAULTSAPWD	Can be used to assign a blank password to the "sa" login.

However, because these commands are not available, specifying them on the command line when you run the SQL Server 2000 Desktop Engine installation through the Microsoft Windows Installer has no affect. This behavior is also mentioned in the Readme.txt file included with the SQL Server 2000 Desktop Engine installation.

Back to the top

REFERENCES

For additional information about MSDE and SQL Server 2000 Service Pack 3, click the following article number to view the article in the Microsoft Knowledge Base:

810826 (http://support.microsoft.com/kb/810826/EN-US/ ) INF: New Switches in MSDE Service Pack 3 Setup

See the "Desktop Engine Setup Parameters" topic in the Readme.txt file that is included with SQL Server 2000 Desktop Engine installation.

For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

227091 (http://support.microsoft.com/kb/227091/EN-US/ ) Command-Line Switches for the Microsoft Windows Installer Tool

280352 (http://support.microsoft.com/kb/280352/EN-US/ ) HOWTO: Install SQL Server CE from the Command Line and Generate a Log File

Back to the top

APPLIES TO

Microsoft SQL Server 2000 Desktop Engine (Windows)
Microsoft SQL Server 2000 Desktop Engine (MSDE) SP1

Back to the top

kbbug kbpending KB285103

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top