SQL Server Report Services Configuring Issue | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Server Report Services Configuring Issue

SQL Server 2005 Sp2 Windows Server 2003 Sp2 When i open the Reporting Services Configuration Manager on our newly installed SQL 2005 box i get a red X on "Web Service Identity". The window in question states that "The Web Service runs under the ASP .NET Machine account under IIS 5 or …" with what looks to be a text entry box that is grayed out with the label "ASP .NET Service Account. The text entry box that is grayed out is blank. When the Apply button is pressed a Task Status box opens at the bottom that states "There was an error setting the identity for the web service. The previously set identity will still be used." When the option for "Tell me more about the problem and how to resolve it." is pressed i get a dialog box that has two lines of text reading: "ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occured in the WMI provider. Error Code 80070005" "at Report ServicesConfigUI.RSReportSErverAdmin.SetWebServiceIdentity(StringapplicationPool)" I have the same question ashttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=295080&SiteID=1 but the difference is I my operation system is windows 2003.
—————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
As per that post:
…in the %installPath%Reporting ServicesReportServer directory there is a file called rsreportserver.config … grant the account machinenameASPNET access to this file…
Can you check whether the ASP.NET account has relevant privileges on the directory and file. Alsohttp://technet.microsoft.com/en-us/library/ms189361.aspx fyi (may be you have gone through it already). Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
it has maximum permission that folder and file —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
managed to fixe this by recreating Report server and report manager virtual directories —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
]]>