Reporting Services Configuration Manager

I'm trying to install SCE2007 but have run into the following problem.
I've installed SQL 2005 Express with Advanced Services on a W2k3 x64 SP2
machine. In configuring Reporting Services everything looks good except the
Web Services Identity status is a red X. I'm getting the message "object
reference not set to an instance of an object" when I click on the red X. I'm
using Local Service for all service accounts including the App Pool in IIS 7.
I've been through all th eonline help and forum posts I can find but haven't
been able to resolve the issue. All help appreciated.On Nov 30, 12:51 pm, lloydswylie
<lloydswy...@.discussions.microsoft.com> wrote:
> I'm trying to install SCE2007 but have run into the following problem.
> I've installed SQL 2005 Express with Advanced Services on a W2k3 x64 SP2
> machine. In configuring Reporting Services everything looks good except the
> Web Services Identity status is a red X. I'm getting the message "object
> reference not set to an instance of an object" when I click on the red X. I'm
> using Local Service for all service accounts including the App Pool in IIS 7.
> I've been through all th eonline help and forum posts I can find but haven't
> been able to resolve the issue. All help appreciated.
This is just a stab in the dark here; but, have you checked that the
RPC/Remote Procedure Call service is running (via: right-click My
Computer >> select Manage >> select Services and Applications >>
Services). Also, if you can't find an alternative solution, sometimes
an uninstall and reinstall of SSExAS might resolve the issue. Also,
keep in mind that SSRS via SSExAS vs SSRS from the SQL Server Std
Edition and above do not have the same remote functionality, etc. Hope
this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks for your post. The RPC service is running and I've already tried the
reinstall. Any idea what "object reference" the message is referring to?
Thanks.
"EMartinez" wrote:
> On Nov 30, 12:51 pm, lloydswylie
> <lloydswy...@.discussions.microsoft.com> wrote:
> > I'm trying to install SCE2007 but have run into the following problem.
> >
> > I've installed SQL 2005 Express with Advanced Services on a W2k3 x64 SP2
> > machine. In configuring Reporting Services everything looks good except the
> > Web Services Identity status is a red X. I'm getting the message "object
> > reference not set to an instance of an object" when I click on the red X. I'm
> > using Local Service for all service accounts including the App Pool in IIS 7.
> > I've been through all th eonline help and forum posts I can find but haven't
> > been able to resolve the issue. All help appreciated.
>
> This is just a stab in the dark here; but, have you checked that the
> RPC/Remote Procedure Call service is running (via: right-click My
> Computer >> select Manage >> select Services and Applications >>
> Services). Also, if you can't find an alternative solution, sometimes
> an uninstall and reinstall of SSExAS might resolve the issue. Also,
> keep in mind that SSRS via SSExAS vs SSRS from the SQL Server Std
> Edition and above do not have the same remote functionality, etc. Hope
> this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||Hi
The red X generally indicates a difference between the config settings
and WMI provider settings, which is what the interface reads . Try
these steps
1. Open rsreportserver.config and check the webservice account
settings. Make sure that the account is same as the one specified in
the IIS App pool .
2. Try creating a new app pool and click on apply when you have
created that . Then do an IIS reset .
Try not to use vs for editing the config files as it tends to add
entries to the xml tags which cause more grief .
Cheers
Shai
On Dec 3, 4:54 am, lloydswylie <lloydswy...@.discussions.microsoft.com>
wrote:
> Thanks for your post. The RPC service is running and I've already tried the
> reinstall. Any idea what "object reference" the message is referring to?
> Thanks.
>
> "EMartinez" wrote:
> > On Nov 30, 12:51 pm, lloydswylie
> > <lloydswy...@.discussions.microsoft.com> wrote:
> > > I'm trying to install SCE2007 but have run into the following problem.
> > > I've installed SQL 2005 Express with Advanced Services on a W2k3 x64 SP2
> > > machine. In configuring Reporting Services everything looks good except the
> > > Web Services Identity status is a red X. I'm getting the message "object
> > > reference not set to an instance of an object" when I click on the red X. I'm
> > > using Local Service for all service accounts including the App Pool in IIS 7.
> > > I've been through all th eonline help and forum posts I can find but haven't
> > > been able to resolve the issue. All help appreciated.
> > This is just a stab in the dark here; but, have you checked that the
> > RPC/Remote Procedure Call service is running (via: right-click My
> > Computer >> select Manage >> select Services and Applications >>
> > Services). Also, if you can't find an alternative solution, sometimes
> > an uninstall and reinstall of SSExAS might resolve the issue. Also,
> > keep in mind that SSRS via SSExAS vs SSRS from the SQL Server Std
> > Edition and above do not have the same remote functionality, etc. Hope
> > this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant- Hide quoted text -
> - Show quoted text -|||Thanks for your reply. I had missed one of the spots in the App pool that I
needed to change to Local Service. Now that's solved but SCE2007 install
still quits saying I haven't configured the Report Server.
"shaikat.das@.gmail.com" wrote:
> Hi
> The red X generally indicates a difference between the config settings
> and WMI provider settings, which is what the interface reads . Try
> these steps
> 1. Open rsreportserver.config and check the webservice account
> settings. Make sure that the account is same as the one specified in
> the IIS App pool .
> 2. Try creating a new app pool and click on apply when you have
> created that . Then do an IIS reset .
> Try not to use vs for editing the config files as it tends to add
> entries to the xml tags which cause more grief .
> Cheers
> Shai
>
> On Dec 3, 4:54 am, lloydswylie <lloydswy...@.discussions.microsoft.com>
> wrote:
> > Thanks for your post. The RPC service is running and I've already tried the
> > reinstall. Any idea what "object reference" the message is referring to?
> > Thanks.
> >
> >
> >
> > "EMartinez" wrote:
> > > On Nov 30, 12:51 pm, lloydswylie
> > > <lloydswy...@.discussions.microsoft.com> wrote:
> > > > I'm trying to install SCE2007 but have run into the following problem.
> >
> > > > I've installed SQL 2005 Express with Advanced Services on a W2k3 x64 SP2
> > > > machine. In configuring Reporting Services everything looks good except the
> > > > Web Services Identity status is a red X. I'm getting the message "object
> > > > reference not set to an instance of an object" when I click on the red X. I'm
> > > > using Local Service for all service accounts including the App Pool in IIS 7.
> > > > I've been through all th eonline help and forum posts I can find but haven't
> > > > been able to resolve the issue. All help appreciated.
> >
> > > This is just a stab in the dark here; but, have you checked that the
> > > RPC/Remote Procedure Call service is running (via: right-click My
> > > Computer >> select Manage >> select Services and Applications >>
> > > Services). Also, if you can't find an alternative solution, sometimes
> > > an uninstall and reinstall of SSExAS might resolve the issue. Also,
> > > keep in mind that SSRS via SSExAS vs SSRS from the SQL Server Std
> > > Edition and above do not have the same remote functionality, etc. Hope
> > > this helps.
> >
> > > Regards,
> >
> > > Enrique Martinez
> > > Sr. Software Consultant- Hide quoted text -
> >
> > - Show quoted text -
>|||If RS is configured and shows it then I would try to restart the RS
server . Obviously SCE install cannot detect the current RS settings ,
the only thing that comes to mind is that the installation steps were
not sequential. If you do resolve it , post back and let me know as I
am curious to see what is causing the issue.
Cheers
Shai
On Dec 3, 11:58 am, lloydswylie
<lloydswy...@.discussions.microsoft.com> wrote:
> Thanks for your reply. I had missed one of the spots in the App pool that I
> needed to change to Local Service. Now that's solved but SCE2007 install
> still quits saying I haven't configured the Report Server.
>
> "shaikat...@.gmail.com" wrote:
> > Hi
> > The red X generally indicates a difference between the config settings
> > and WMI provider settings, which is what the interface reads . Try
> > these steps
> > 1. Open rsreportserver.config and check the webservice account
> > settings. Make sure that the account is same as the one specified in
> > the IIS App pool .
> > 2. Try creating a new app pool and click on apply when you have
> > created that . Then do an IIS reset .
> > Try not to use vs for editing the config files as it tends to add
> > entries to the xml tags which cause more grief .
> > Cheers
> > Shai
> > On Dec 3, 4:54 am, lloydswylie <lloydswy...@.discussions.microsoft.com>
> > wrote:
> > > Thanks for your post. The RPC service is running and I've already tried the
> > > reinstall. Any idea what "object reference" the message is referring to?
> > > Thanks.
> > > "EMartinez" wrote:
> > > > On Nov 30, 12:51 pm, lloydswylie
> > > > <lloydswy...@.discussions.microsoft.com> wrote:
> > > > > I'm trying to install SCE2007 but have run into the following problem.
> > > > > I've installed SQL 2005 Express with Advanced Services on a W2k3 x64 SP2
> > > > > machine. In configuring Reporting Services everything looks good except the
> > > > > Web Services Identity status is a red X. I'm getting the message "object
> > > > > reference not set to an instance of an object" when I click on the red X. I'm
> > > > > using Local Service for all service accounts including the App Pool in IIS 7.
> > > > > I've been through all th eonline help and forum posts I can find but haven't
> > > > > been able to resolve the issue. All help appreciated.
> > > > This is just a stab in the dark here; but, have you checked that the
> > > > RPC/Remote Procedure Call service is running (via: right-click My
> > > > Computer >> select Manage >> select Services and Applications >>
> > > > Services). Also, if you can't find an alternative solution, sometimes
> > > > an uninstall and reinstall of SSExAS might resolve the issue. Also,
> > > > keep in mind that SSRS via SSExAS vs SSRS from the SQL Server Std
> > > > Edition and above do not have the same remote functionality, etc. Hope
> > > > this helps.
> > > > Regards,
> > > > Enrique Martinez
> > > > Sr. Software Consultant- Hide quoted text -
> > > - Show quoted text -- Hide quoted text -
> - Show quoted text -|||On Dec 2, 10:35 pm, shaikat...@.gmail.com wrote:
> If RS is configured and shows it then I would try to restart the RS
> server . Obviously SCE install cannot detect the current RS settings ,
> the only thing that comes to mind is that the installation steps were
> not sequential. If you do resolve it , post back and let me know as I
> am curious to see what is causing the issue.
> Cheers
> Shai
> On Dec 3, 11:58 am, lloydswylie
> <lloydswy...@.discussions.microsoft.com> wrote:
> > Thanks for your reply. I had missed one of the spots in the App pool that I
> > needed to change to Local Service. Now that's solved but SCE2007 install
> > still quits saying I haven't configured the Report Server.
> > "shaikat...@.gmail.com" wrote:
> > > Hi
> > > The red X generally indicates a difference between the config settings
> > > and WMI provider settings, which is what the interface reads . Try
> > > these steps
> > > 1. Open rsreportserver.config and check the webservice account
> > > settings. Make sure that the account is same as the one specified in
> > > the IIS App pool .
> > > 2. Try creating a new app pool and click on apply when you have
> > > created that . Then do an IIS reset .
> > > Try not to use vs for editing the config files as it tends to add
> > > entries to the xml tags which cause more grief .
> > > Cheers
> > > Shai
> > > On Dec 3, 4:54 am, lloydswylie <lloydswy...@.discussions.microsoft.com>
> > > wrote:
> > > > Thanks for your post. The RPC service is running and I've already tried the
> > > > reinstall. Any idea what "object reference" the message is referring to?
> > > > Thanks.
> > > > "EMartinez" wrote:
> > > > > On Nov 30, 12:51 pm, lloydswylie
> > > > > <lloydswy...@.discussions.microsoft.com> wrote:
> > > > > > I'm trying to install SCE2007 but have run into the following problem.
> > > > > > I've installed SQL 2005 Express with Advanced Services on a W2k3 x64 SP2
> > > > > > machine. In configuring Reporting Services everything looks good except the
> > > > > > Web Services Identity status is a red X. I'm getting the message "object
> > > > > > reference not set to an instance of an object" when I click on the red X. I'm
> > > > > > using Local Service for all service accounts including the App Pool in IIS 7.
> > > > > > I've been through all th eonline help and forum posts I can find but haven't
> > > > > > been able to resolve the issue. All help appreciated.
> > > > > This is just a stab in the dark here; but, have you checked that the
> > > > > RPC/Remote Procedure Call service is running (via: right-click My
> > > > > Computer >> select Manage >> select Services and Applications >>
> > > > > Services). Also, if you can't find an alternative solution, sometimes
> > > > > an uninstall and reinstall of SSExAS might resolve the issue. Also,
> > > > > keep in mind that SSRS via SSExAS vs SSRS from the SQL Server Std
> > > > > Edition and above do not have the same remote functionality, etc. Hope
> > > > > this helps.
> > > > > Regards,
> > > > > Enrique Martinez
> > > > > Sr. Software Consultant- Hide quoted text -
> > > > - Show quoted text -- Hide quoted text -
> > - Show quoted text -
Also, you might verify that the SSRS service is running (via: right-
click My Computer >> select Manage >> Services and Applications >>
Services >> SQL Server Reporting Services (MSSQLSERVER)). Verify that
your Virtual Directories for SSRS (ReportServer and Reports) have been
created. Another troubleshooting idea is to run SQL Profiler during
the SCE2007 Install and activate Exceptions and SQL Statements to see
if an error pops up in the process and if a T-SQL call, etc occurs
directly before it. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant