Error message when you install SQL Server 2005 Service Pack 1: "Failed to fetch IIS SSLStoreName.error -2146646015" (921111)


The information in this article applies to:

  • Microsoft SQL Server 2005 Service Pack 1

SYMPTOMS

Consider the following scenario:
  • You configure the computer to use Secure Sockets Layer (SSL) for Microsoft SQL Server 2005 Reporting Services.
  • Then, you try to install Microsoft SQL Server 2005 Service Pack 1 (SP1).
In this scenario, you receive the following error message:
Failed to Fetch IIS SSLStoreName.Error -2146646015
When this problem occurs, the following messages are logged in the RS9_Hotfix_KB913090_sqlrun_rs.msp.log file.

Note The RS9_Hotfix_KB913090_sqlrun_rs.msp.log file is located in the %WinDir%\Hotfix\RS9\Logs folder.
MSI (s) (00!68) [15:48:15:194]: PROPERTY CHANGE: Adding DefSiteStarted property. Its value is '1'.
MSI (s) (00!68) [15:48:15:194]: PROPERTY CHANGE: Adding _RsLocalInstall property. Its value is '0'.
<EndFunc Name='WebFindBase' Return='0' GetLastError='0'>
<Func Name='GetXMLAttributeValue'>
Error to get a named attribute userName
<EndFunc Name='GetXMLAttributeValue' Return='2' GetLastError='0'>
MSI (s) (00!68) [15:48:15:334]: PROPERTY CHANGE: Adding RSUSESSL property. Its value is '1'.
Info: SSL is enabled on this machine.
MSI (s) (00!68) [15:48:15:334]: PROPERTY CHANGE: Adding SecureConnectionLevel property. Its value is '3'.
Setting SecureConnectionLevel to 3
Data not found, no certificate is set

Failed to Fetch IIS SSLStoreName.Error -2146646015
Error Code: 0x80077379 (29561)
Windows Error Text: Source File Name: sqlca\sqlrsguica.cpp
Compiler Timestamp: Date Time
Function Name: CheckRSSetupRequirements
Source Line Number: 935

MSI (s) (00!68) [15:48:15:366]: Transforming table Error.

MSI (s) (00!68) [15:48:15:366]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (00!68) [15:48:15:366]: Transforming table Error.

MSI (s) (00!68) [15:48:15:366]: Transforming table Error.

MSI (s) (00!68) [15:48:15:366]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (00!68) [15:48:15:366]: Transforming table Error.

MSI (s) (00!68) [15:48:15:366]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (00!68) [15:48:15:366]: Transforming table Error.

MSI (s) (00!68) [15:48:15:366]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 29561
MSI (s) (00!68) [15:48:15:366]: Transforming table Error.

MSI (s) (00!68) [15:48:15:366]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (00!68) [15:48:15:381]: Transforming table Error.

MSI (s) (00!68) [15:48:15:381]: Transforming table Error.

MSI (s) (00!68) [15:48:15:381]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (00!68) [15:48:15:381]: Transforming table Error.

MSI (s) (00!68) [15:48:15:381]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (00!68) [15:48:15:381]: Transforming table Error.

MSI (s) (00!68) [15:48:15:381]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (00!68) [15:48:15:381]: Product: Microsoft SQL Server 2005 Reporting Services -- Error 29561. SQL Server Setup failed to retrieve the SSL Certificate Name.

Error 29561. SQL Server Setup failed to retrieve the SSL Certificate Name.
<Failure Type='Fatal' Error='29561'>
<EndFunc Name='LaunchFunction' Return='29561' GetLastError='0'>
MSI (s) (00:30) [15:48:15:381]: Transforming table InstallExecuteSequence.

MSI (s) (00:30) [15:48:15:381]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (00:30) [15:48:15:381]: Transforming table InstallExecuteSequence.

MSI (s) (00:30) [15:48:15:381]: Transforming table InstallExecuteSequence.

MSI (s) (00:30) [15:48:15:381]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (00:30) [15:48:15:381]: Transforming table InstallExecuteSequence.

MSI (s) (00:30) [15:48:15:381]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (00:30) [15:48:15:381]: Transforming table InstallExecuteSequence.

MSI (s) (00:30) [15:48:15:381]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
Action ended 15:48:15: CheckRSSetupRequirements.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3.
Action ended 15:48:15: INSTALL. Return value 3.

WORKAROUND

To work around this problem, follow these steps:
  1. Disable SSL for SQL Server 2005 Reporting Services.
  2. Reinstall SQL Server 2005 SP1.
  3. Enable SSL for SQL Server 2005 Reporting Services.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Modification Type:MajorLast Reviewed:7/19/2006
Keywords:kbprb kbExpertiseAdvanced kbsql2005setup KB921111 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.