I'm having problem configuring Report Server 2005 on Windows Server 2008
Enterprise.
After I installed SQL Server 2005 Reporter Server I execute "Report Services
Configuration" and in "Web Service Identity" I can't change the "Aplication
Pool" to "ReportServerPool" in "Report Manager" field. In field "Report
Server" the change is OK, because of this the Report Server site doesn't
work, if I use "Classic .Net Pool", the site doens't work either, but the
error is different this time says that the web service is unable to access
security information, I tried to change the ReportServerPool to classic but
no result, tried to change the service account in the ReportServicePool, no
result either.


The error when I try to change to ReportServerPool

ReportServicesConfigUI.WMIProvider.WMIProviderExce ption: An unknown error
has occurred in the WMI Provider. Error Code 800708AC at
ReportServicesConfigUI.WMIProvider.RSReportServerA dmin.SetWebServiceIdentity(String
applicationPool)

If I change both fields, Report Manager and Report Server to classic the Web
Service Identity is OK, but the site shows an error msg stating "The report
server is not responding".
If I change both fields to DefaultAppPool the service identity is OK, but
the site shows a 500.23 error msg and change the service account to Network
Service.

How can I configure Report Server to work with IIS7.

Tks
Marcos Benites
Trax Computer Advisor
Blog: HTTP://mbenites-trax.spaces.live.com
http://www.traxcomputer.com.br
IM: mbenites@traxcomputer.com.br

Hi Marcos,
I understand that you could not configure your SQL Server 2005 Reporting
Service on your Windows Server 2008 Enterprise Edition. The error is
regarding WMI Provider.
If I have misunderstood, please let me know.

First I recommend that you refer to this article to see if you had any
different steps:
How to: Install and Configure Reporting Services on Windows Server 2008
http://msdn2.microsoft.com/en-us/library/bb839480.aspx

Since this issue is most likely related to IIS 7.0, I also recommend that
you refer to this article to see if there are any prerequisites not
satisfied:
How to: Install 32-bit Reporting Services on Windows Vista
http://msdn2.microsoft.com/en-us/library/bb630430.aspx

If your steps are no problem and this issue persists, please feel free to
let me know. Now I also submit a ticket to our lab to establish a test
environment for checking if I can reproduce your issue. However the process
may need a bit long time. I appreciate your patience.

If you have any other questions or concerns, please feel free to let me
know. Have a nice day!


Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@microsoft.com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

I'm also having this same problem, but Im trying to run reporting services in
my PC with Windows Vista.

I've already checked all the steps about the installation on Windows Vista
and it seems ok. The only "difference" is that IIS was telling me that I
should install a CGI "component", what I did by going on add windows features
-> world wide web services -> application developement features -> CGI.

I dont understand why something that used to be so simple in WS 2003 became
so hard in Vista/2008, but I hope we can figure out a solution.


Vladimir




""Charles Wang [MSFT]"" wrote:

> Hi Marcos,
> I understand that you could not configure your SQL Server 2005 Reporting
> Service on your Windows Server 2008 Enterprise Edition. The error is
> regarding WMI Provider.
> If I have misunderstood, please let me know.
>
> First I recommend that you refer to this article to see if you had any
> different steps:
> How to: Install and Configure Reporting Services on Windows Server 2008
> http://msdn2.microsoft.com/en-us/library/bb839480.aspx
>
> Since this issue is most likely related to IIS 7.0, I also recommend that
> you refer to this article to see if there are any prerequisites not
> satisfied:
> How to: Install 32-bit Reporting Services on Windows Vista
> http://msdn2.microsoft.com/en-us/library/bb630430.aspx
>
> If your steps are no problem and this issue persists, please feel free to
> let me know. Now I also submit a ticket to our lab to establish a test
> environment for checking if I can reproduce your issue. However the process
> may need a bit long time. I appreciate your patience.
>
> If you have any other questions or concerns, please feel free to let me
> know. Have a nice day!
>
>
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ================================================== =========
> Delighting our customers is our #1 priority. We welcome your
> comments and suggestions about how we can improve the
> support we provide to you. Please feel free to let my manager
> know what you think of the level of service provided. You can
> send feedback directly to my manager at: msdnmg@microsoft.com.
> ================================================== =========
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscripti...ult.aspx#notif
> ications.
>
> Note: The MSDN Managed Newsgroup support offering is for
> non-urgent issues where an initial response from the community
> or a Microsoft Support Engineer within 1 business day is acceptable.
> Please note that each follow up response may take approximately
> 2 business days as the support professional working with you may
> need further investigation to reach the most efficient resolution.
> The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by
> contacting Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscripti...t/default.aspx.
> ================================================== ==========
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ================================================== =======
>
>
>

Just a side note, that I was able to change the application pool of the
Report Manager, doing it in IIS Manager. It didnt solve the problem, since Im
still getting error messages, but when I go check the application pool on
Reporting Services Configuration Manager, it tells me that the Application
pool is "Classic .Net Application Pool", so it seems to have worked.


Another thing is that, in my case, I was having some kind of problem with
ISAPI and CGI Restrictions so I had to go to IIS Manager, clicked on the
server and on "ISAPI and CGI Restrictions" -> Edit Feature Settings I checked
both options available.


Hope this s on solving this problem.


Vladimir


"Vladimir_RN" wrote:

> I'm also having this same problem, but Im trying to run reporting services in
> my PC with Windows Vista.
>
> I've already checked all the steps about the installation on Windows Vista
> and it seems ok. The only "difference" is that IIS was telling me that I
> should install a CGI "component", what I did by going on add windows features
> -> world wide web services -> application developement features -> CGI.
>
> I dont understand why something that used to be so simple in WS 2003 became
> so hard in Vista/2008, but I hope we can figure out a solution.
>
>
> Vladimir
>
>
>
>
> ""Charles Wang [MSFT]"" wrote:
>
> > Hi Marcos,
> > I understand that you could not configure your SQL Server 2005 Reporting
> > Service on your Windows Server 2008 Enterprise Edition. The error is
> > regarding WMI Provider.
> > If I have misunderstood, please let me know.
> >
> > First I recommend that you refer to this article to see if you had any
> > different steps:
> > How to: Install and Configure Reporting Services on Windows Server 2008
> > http://msdn2.microsoft.com/en-us/library/bb839480.aspx
> >
> > Since this issue is most likely related to IIS 7.0, I also recommend that
> > you refer to this article to see if there are any prerequisites not
> > satisfied:
> > How to: Install 32-bit Reporting Services on Windows Vista
> > http://msdn2.microsoft.com/en-us/library/bb630430.aspx
> >
> > If your steps are no problem and this issue persists, please feel free to
> > let me know. Now I also submit a ticket to our lab to establish a test
> > environment for checking if I can reproduce your issue. However the process
> > may need a bit long time. I appreciate your patience.
> >
> > If you have any other questions or concerns, please feel free to let me
> > know. Have a nice day!
> >
> >
> > Best regards,
> > Charles Wang
> > Microsoft Online Community Support
> > ================================================== =========
> > Delighting our customers is our #1 priority. We welcome your
> > comments and suggestions about how we can improve the
> > support we provide to you. Please feel free to let my manager
> > know what you think of the level of service provided. You can
> > send feedback directly to my manager at: msdnmg@microsoft.com.
> > ================================================== =========
> > Get notification to my posts through email? Please refer to
> > http://msdn.microsoft.com/subscripti...ult.aspx#notif
> > ications.
> >
> > Note: The MSDN Managed Newsgroup support offering is for
> > non-urgent issues where an initial response from the community
> > or a Microsoft Support Engineer within 1 business day is acceptable.
> > Please note that each follow up response may take approximately
> > 2 business days as the support professional working with you may
> > need further investigation to reach the most efficient resolution.
> > The offering is not appropriate for situations
> > that require urgent, real-time or phone-based interactions or complex
> > project analysis and dump analysis issues. Issues of this nature are best
> > handled working with a dedicated Microsoft Support Engineer by
> > contacting Microsoft Customer Support Services (CSS) at
> > http://msdn.microsoft.com/subscripti...t/default.aspx.
> > ================================================== ==========
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> > ================================================== =======
> >
> >
> >

Hi Charles,

tks for your answer, I'll chek those articles and let you know if it solved
my problem.
I checked the WMI Provider and it's ok, but who knows if it's has a problem
that I could not see.

tks
Marcos Benites

""Charles Wang [MSFT]"" <changliw@online.microsoft.com> escreveu na mensagem
news:sDXa27spIHA.5740@TK2MSFTNGHUB02.phx.gbl...
> Hi Marcos,
> I understand that you could not configure your SQL Server 2005 Reporting
> Service on your Windows Server 2008 Enterprise Edition. The error is
> regarding WMI Provider.
> If I have misunderstood, please let me know.
>
> First I recommend that you refer to this article to see if you had any
> different steps:
> How to: Install and Configure Reporting Services on Windows Server 2008
> http://msdn2.microsoft.com/en-us/library/bb839480.aspx
>
> Since this issue is most likely related to IIS 7.0, I also recommend that
> you refer to this article to see if there are any prerequisites not
> satisfied:
> How to: Install 32-bit Reporting Services on Windows Vista
> http://msdn2.microsoft.com/en-us/library/bb630430.aspx
>
> If your steps are no problem and this issue persists, please feel free to
> let me know. Now I also submit a ticket to our lab to establish a test
> environment for checking if I can reproduce your issue. However the
> process
> may need a bit long time. I appreciate your patience.
>
> If you have any other questions or concerns, please feel free to let me
> know. Have a nice day!
>
>
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ================================================== =========
> Delighting our customers is our #1 priority. We welcome your
> comments and suggestions about how we can improve the
> support we provide to you. Please feel free to let my manager
> know what you think of the level of service provided. You can
> send feedback directly to my manager at: msdnmg@microsoft.com.
> ================================================== =========
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscripti...ult.aspx#notif
> ications.
>
> Note: The MSDN Managed Newsgroup support offering is for
> non-urgent issues where an initial response from the community
> or a Microsoft Support Engineer within 1 business day is acceptable.
> Please note that each follow up response may take approximately
> 2 business days as the support professional working with you may
> need further investigation to reach the most efficient resolution.
> The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by
> contacting Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscripti...t/default.aspx.
> ================================================== ==========
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> ================================================== =======
>
>

Hi Charles,

Well now the report service is working fine, but I discovered what was
wrong.

My instalation and configuration was conforming those articles, but the
report service didn't work, the article was full because it says that
the application pool should be Classic .Net AppPool, and when I used this
pool in Report Server And Report Manager, the Web Service Identity did not
get an error, but the site did not work showing a security error msg, then
to correct this error I did the following:

I granted the Read permission to the IIS_IUSRS group to the folders
ReportManager and ReportServer I tried only to grant read permission to the
files ApplicationHost.config file and/or Web.config file in those folders,
but didn't work.
I don't know how it would impact the security in those folders, but at least
the SQL 2005 Report Service is working.

With the ReportServerPool created during the installing didn't work.

Tks


""Charles Wang [MSFT]"" <changliw@online.microsoft.com> escreveu na mensagem
news:sDXa27spIHA.5740@TK2MSFTNGHUB02.phx.gbl...
> Hi Marcos,
> I understand that you could not configure your SQL Server 2005 Reporting
> Service on your Windows Server 2008 Enterprise Edition. The error is
> regarding WMI Provider.
> If I have misunderstood, please let me know.
>
> First I recommend that you refer to this article to see if you had any
> different steps:
> How to: Install and Configure Reporting Services on Windows Server 2008
> http://msdn2.microsoft.com/en-us/library/bb839480.aspx
>
> Since this issue is most likely related to IIS 7.0, I also recommend that
> you refer to this article to see if there are any prerequisites not
> satisfied:
> How to: Install 32-bit Reporting Services on Windows Vista
> http://msdn2.microsoft.com/en-us/library/bb630430.aspx
>
> If your steps are no problem and this issue persists, please feel free to
> let me know. Now I also submit a ticket to our lab to establish a test
> environment for checking if I can reproduce your issue. However the
> process
> may need a bit long time. I appreciate your patience.
>
> If you have any other questions or concerns, please feel free to let me
> know. Have a nice day!
>
>
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ================================================== =========
> Delighting our customers is our #1 priority. We welcome your
> comments and suggestions about how we can improve the
> support we provide to you. Please feel free to let my manager
> know what you think of the level of service provided. You can
> send feedback directly to my manager at: msdnmg@microsoft.com.
> ================================================== =========
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscripti...ult.aspx#notif
> ications.
>
> Note: The MSDN Managed Newsgroup support offering is for
> non-urgent issues where an initial response from the community
> or a Microsoft Support Engineer within 1 business day is acceptable.
> Please note that each follow up response may take approximately
> 2 business days as the support professional working with you may
> need further investigation to reach the most efficient resolution.
> The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by
> contacting Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscripti...t/default.aspx.
> ================================================== ==========
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> ================================================== =======
>
>