You are currently offline, waiting for your internet to reconnect

FIX: Error message when you try to specify the SQL Server 2008 Reporting Services account as the credential for a report server in SharePoint Central Administration: "Unable to connect to Report Server WMI provider"

SYMPTOMS
You configure an instance of Microsoft SQL Server 2008 Reporting Services to run in the SharePoint integrated mode. On the Grant DB Access page in SharePoint Central Administration, you try to specify the Reporting Services account as the credential for the report server. When you do this, you receive the following error message:
Unable to connect to Report Server WMI provider
RESOLUTION

Service pack information

To resolve this problem, obtain the latest service pack for SQL Server 2008. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
968382 How to obtain the latest service pack for SQL Server 2008
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in SQL Server 2008 Service Pack 1.
MORE INFORMATION
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates

Steps to reproduce the problem

  1. Install Windows SharePoint Services or Microsoft Office SharePoint Server on computer A.
  2. Install SQL Server 2008 Reporting Services on computer B.
  3. Log on to computer A by using a domain account. The domain account is a user on computer A, and the account is a member of the Farm Administrators group in Windows SharePoint Services or in SharePoint Server.
  4. Run the Reporting Services service under another domain account on computer B. The domain account is a member of the local BUILTIN\Administrators group on computer B.
  5. On the Grant DB Access page in SharePoint Central Administration, specify the Reporting Services account as the credential for the report server.
Properties

Article ID: 968599 - Last Review: 04/08/2009 00:08:06 - Revision: 1.0

Microsoft SQL Server 2008 Reporting Services

  • kbsurveynew kbexpertiseadvanced kbqfe kbfix KB968599
Feedback
p;t="> var varClickTracking = 1; var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" age);" class="ng-binding" id="language-es-py">Paraguay - Español
Venezuela - Español
>://c1.microsoft.com/c.gif?DI=4050&did=1&t="> var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" ')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?"> y>