PRB: SQL Server 2000 Service Pack 3 Setup Fails If Windows Security Policy Is Set (810343)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions) SP3, when used with:
    • Microsoft Windows 2000 Advanced Server
BUG #: 91351 (Webdata)

SYMPTOMS


When you install SQL Server 2000 Service Pack 3, the installation may fail after you receive the following message in the Digital Signature Not Found dialog box.

The software you are about to install does not contain a
Microsoft digital signature. Therefore, there is no
guarantee that this software works correctly with
Windows.

Unknown software package

An error message similar to the following is also logged in the Sqlstp.log setup log file:

Process Exit Code: (-2147312566) Error loading type library/DLL.

CAUSE

The Unsigned driver installation security option in the Local Security Policy of Microsoft Windows is set to Do not allow installation.

-or-

The Driver Signing options system property for the computer is set to Block-Prevent installation of unsigned files.

WORKAROUND

To work around this problem, follow these steps:
  1. When you install SQL Server 2000 Service Pack 3 with the Windows local security policy, change the Unsigned driver installation behavior policy to Silently succeed or Warn but allow installation.
  2. When you install SQL Server 2000 Service Pack 3 with the Driver signing options for the computer, change the options to Ignore- Install all files, regardless of file signature, or to Warn-Display a message before installing an unsigned file.

MORE INFORMATION

To change the Unsigned driver installation behavior security policy, follow these steps:
  1. Click Start, point to Settings, and then click Control Panel.
  2. Double-click Administrative Tools.
  3. Double-click Local Security Policy.
  4. Expand Local Policies, and then double-click Security Options.
  5. Open the Local Security Policy Settings dialog by double-clicking Unsigned driver installation behavior.
  6. Select the local policy setting. To select the local policy setting, click any one of the following options:
    • Silently succeed
    • Warn but allow installation
To change the Driver Signing options, follow these steps:
  1. Right-click My Computer, and then click to select Properties.
  2. Click the Hardware tab.
  3. Click Driver Signing.
  4. In the Driver Signing Options dialog box, under File signature verification, click to select either of the following options:
    • Ignore- Install all files, regardless of file signature

      -or-
    • Warn-Display a message before installing an unsigned file

REFERENCES

For additional information about the latest service pack for Microsoft SQL Server 2000, click the article number below to view the article in the Microsoft Knowledge Base:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack

Modification Type:MajorLast Reviewed:6/6/2003
Keywords:kbSQLServ2000sp3fea kbprb KB810343 kbAudDeveloper
©2002 Microsoft Corporation. All rights reserved.