"Provider Load Failure" in SSRS Configuration

I am receiving the "Provider Load Failure" message when I start the SSRS Configuration Tool on my report server.

As suggested on other threads, I have checked the reportingserviceswmi.dll and it is version 2005.90.1399.0 and the WMI service is running.

Any suggestions on what to do next?

I solved this myself by piecing together a couple of other posts.

I tried some of the remedies that basically entailed reregistering all of the wmi dll's and none of them worked but then I searched out "reportingserviceswmi.dll" and found that it wasn't in the c:\windows\system32\wbem folder. I tried reregistering it in the folder where it resided and it didn't fix the problem. Next I copied reportingserviceswmi.dll to the wbem folder and registered it there and the problem was resolved.

Example: c:\windows\system32\regsvr32 c:\windows\system32\wbem\reportingserviceswmi.dll

"Encryption not suppprted on the client" error

I am getting the following:

SQL Server could not connet to the database service for server configuration. The error was: [Microsoft][SQL Native Client] Encryption not suppprted on the client. Refer to sever logs and setup logs for more information. For details on how to view setup logs, see :how to View Setup Log Files" in SQL Server Books Online.

Ouch...anyone?

Here's my log file:

Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Professional (Build 5384)
Time : Sat Jul 01 08:01:37 2006

Machine : JOHN-PC
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.2047.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_JOHN-PC_SQLSupport_1.log
--
Machine : JOHN-PC
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_JOHN-PC_SQLNCLI_1.log
--
Machine : JOHN-PC
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.2047.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_JOHN-PC_SqlWriter_1.log
--
Machine : JOHN-PC
Product : SQL Server Database Services
Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
--
Machine : JOHN-PC
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.1.2047.00
Install : Failed
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_JOHN-PC_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
Error Number : 29515
--

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.

Time : Sat Jul 01 08:07:48 2006

List of log files:
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_JOHN-PC_Core(Local).log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_JOHN-PC_SQLSupport_1.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_JOHN-PC_SQLNCLI_1.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_JOHN-PC_SqlWriter_1.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_JOHN-PC_SQL.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_JOHN-PC_Datastore.xml
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_JOHN-PC_.NET Framework 2.0.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_JOHN-PC_Support.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_JOHN-PC_Core.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_JOHN-PC_SCC.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_JOHN-PC_WI.log
c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

Can anyone help?

Cheers,

JB

|||

You probably have Encryption on your file system. Please disable encryption then try the installation again.

Thanks

Michelle

|||

Hi Michelle,

How do I tell on Vista if this is so?

cheers,

"Create a Grants Rights Script" error in rs db configaration

Hi,

While I'm trying to configure rs db configuration, I’m getting "Create a Grants Rights Script" error when I click Apply button in rs configuration UI.

For this setup; I’m using 32-bit rs on 64-bit windows 2003 server and trying to connect 64-bit sql db instance on a different 64-bit box . both boxes are in same windows domain. I could also able to create rs db from rs configuration UI successfully. I'm using sql sa credentials and installed SQL SP1 on both boxes. Pl let me know how to fix this error.

Complate error message is,

System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementObjectSearcher.Initialize()
at System.Management.ManagementObjectSearcher.Get()
at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String machine)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String dbServer)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String connectionString, String server, String database, ConfigurationCredentialsType credsType, String account, String password, Boolean upgrade, String dbVersion)

Thanks in advance

Ram

did you ever resolve this problem. I'm gettnig the same error.|||

Hi Greg,

I would suggest to start from here:

http://msdn2.microsoft.com/en-us/library/ms365170.aspx

http://msdn2.microsoft.com/en-us/library/ms159093.aspx

Mihaela

"Create a Grants Rights Script" error in rs db configaration

Hi,

While I'm trying to configure rs db configuration, I’m getting "Create a Grants Rights Script" error when I click Apply button in rs configuration UI.

For this setup; I’m using 32-bit rs on 64-bit windows 2003 server and trying to connect 64-bit sql db instance on a different 64-bit box . both boxes are in same windows domain. I could also able to create rs db from rs configuration UI successfully. I'm using sql sa credentials and installed SQL SP1 on both boxes. Pl let me know how to fix this error.

Complate error message is,

System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementObjectSearcher.Initialize()
at System.Management.ManagementObjectSearcher.Get()
at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String machine)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String dbServer)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String connectionString, String server, String database, ConfigurationCredentialsType credsType, String account, String password, Boolean upgrade, String dbVersion)

Thanks in advance

Ram

did you ever resolve this problem. I'm gettnig the same error.|||

Hi Greg,

I would suggest to start from here:

http://msdn2.microsoft.com/en-us/library/ms365170.aspx

http://msdn2.microsoft.com/en-us/library/ms159093.aspx

Mihaela