SQL Reporting Services Install issue in SharePoint Integrated mode


When trying to set the Web Service Identity within the Reporting Services Configuration Manager in a SharePoint integrated mode , we encountered the following issue

ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070003
   at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)

At first we thought the WMI provider was corrupted and tried to go that route for resolving this issue. After quite some time we figured that it may have been something with the applicationPool and hence started looking at the Web site configuration within IIS. Sure enough, in the ASP.NET tab for the web site, there was no entry for the ASP.NET version. After setting the value to 2.0 , we re-ran the configuration and the issue was fixed.

Resolution:

Check to make sure the right ASP.NET version is selected on your Reporting services website.  While you are there ensure that the ASP.NET web service extension is set to Allowed.  If these dont fix your issue running the aspnet_regiis -i might help as well ( I havent tried this!)

Advertisements

One Response to SQL Reporting Services Install issue in SharePoint Integrated mode

  1. Farida Khan says:

    hi…I was deploying Reporting Services on SQL server 2005. I have no requirement of Interations with sharepoint. But upon getting error messages while setting up RS, i came across your post on https://techdhaan.wordpress.com/category/sql-reporting-services/ and ran the command
    cscript adsutil.vbs set w3svc/NTAuthenticationProviders “NTLM”

    On doing so, i am not getting the error message as below. I reallyu need help as to how can i revert the ran command or correct this issue.
    ===================================

    Cannot connect to moqsqlhq004.

    ===================================

    The server committed a protocol violation. Section=ResponseHeader Detail=CR must be followed by LF (Microsoft.SqlServer.Management.UI.RSClient)

    ——————————
    Program Location:

    at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
    at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
    at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
    at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
    at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
    at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
    at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
    at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: