Hello,
I tried to install SQL Server 2005 Express with Advanced Services under
Windows Vista RC1 x64. However I allways get the following Warning:
"ASP.Net Version Registration Requirement:
Failed to find the ASP.Net Version Registration with Microsoft Internet
Information Services (IIS)."
Having this warning it's not possible to install the Reporting Services.
Are there compatibility issues with IIS7 or am I doing sth. wrong?
MartinHello Martin,
Reporting Services won't be correctly supported until SP2 for SQL Server
2005, due to ship about the same time as Vista does. The IIS7 issue has to
due with the ISAPI filter RS uses. There is a KB article on this topic (920201,
see [0])
[0]: http://support.microsoft.com/kb/920201/en-us
I've tried getting working the RCs to not avail.
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/|||I just think that is goddamn ridiculous
a) we can't use _ANY_ database on Vista until SQL 2005 SP2 comes out.
b) we can't get a DOCUMENTED release date on SP2.
c) we don't know what features are in SP2.
It's like-- all of a sudden; a month after vista ships; we're supposed
to flip the switch and have every dev box in the world using MSDE on
Windows XP on day one and SQL 2005 on Vista the next day.
I just dont understand WTF that company is thinking; it's goddamn
ridiculous
If you dont have enough programmers; hire more-- as it is; a company
that has 50,000 people and they're stressed about having 5,000
programmers working on Vista _AND_ Office 2007 combined?
No wonder google can out-develop you even though they only have 8,000
total employees-- I guess at Google; they don't require 45,000
redundant project managers / excel dorks
-Aaron
Kent Tegels wrote:
> Hello Martin,
> Reporting Services won't be correctly supported until SP2 for SQL Server
> 2005, due to ship about the same time as Vista does. The IIS7 issue has to
> due with the ISAPI filter RS uses. There is a KB article on this topic (920201,
> see [0])
> [0]: http://support.microsoft.com/kb/920201/en-us
> I've tried getting working the RCs to not avail.
> Thanks,
> Kent Tegels
> http://staff.develop.com/ktegels/|||I installed mine last week but not on x64. You have to go in to the Control
Panel / Programs and check all boxes for IIS. You can't rely on the top
check boxes for each subsection. You have to expand the hierarchy for IIS
and manually check ALL items.
Then it will install
--
"Everyone knows something you don't know"
"Martin W" wrote:
> Hello,
> I tried to install SQL Server 2005 Express with Advanced Services under
> Windows Vista RC1 x64. However I allways get the following Warning:
> "ASP.Net Version Registration Requirement:
> Failed to find the ASP.Net Version Registration with Microsoft Internet
> Information Services (IIS)."
> Having this warning it's not possible to install the Reporting Services.
> Are there compatibility issues with IIS7 or am I doing sth. wrong?
> Martin
>|||You have to go to Control Panel/Progams and manually expand the IIS section
so you can MANUALLY CHECK all IIS items. Just doing the top checkboxes won't
work.
--
"Everyone knows something you don't know"
"Martin W" wrote:
> Hello,
> I tried to install SQL Server 2005 Express with Advanced Services under
> Windows Vista RC1 x64. However I allways get the following Warning:
> "ASP.Net Version Registration Requirement:
> Failed to find the ASP.Net Version Registration with Microsoft Internet
> Information Services (IIS)."
> Having this warning it's not possible to install the Reporting Services.
> Are there compatibility issues with IIS7 or am I doing sth. wrong?
> Martin
>|||You have to go to Control Panel/Progams and manually expand the IIS section
so you can MANUALLY CHECK all IIS items. Just doing the top checkboxes won't
work.
--
"Everyone knows something you don't know"
"Martin W" wrote:
> Hello,
> I tried to install SQL Server 2005 Express with Advanced Services under
> Windows Vista RC1 x64. However I allways get the following Warning:
> "ASP.Net Version Registration Requirement:
> Failed to find the ASP.Net Version Registration with Microsoft Internet
> Information Services (IIS)."
> Having this warning it's not possible to install the Reporting Services.
> Are there compatibility issues with IIS7 or am I doing sth. wrong?
> Martin
>sql
Showing posts with label x64. Show all posts
Showing posts with label x64. Show all posts
Friday, March 30, 2012
Reporting Services SQL 2005 x64 standard edition
Can reporting services be upgraded to include data driven subscriptions or must SQL server be upgraded to enterprise edition. Currently I am using SQL 2000 standard edition 32bit with reporting services and data driven subscription. Has the features been changed from 2000 to 2005?
Thanks
Francois
Hello Francois,
SQL Server Reporting Services 2005 is a part of SQL Server 2005 and Data Driven Subscriptions are part of 2005 Enterprise Edition(http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx). From Books On Line (BOL) "Server components require a SQL Server license. You must have a valid SQL Server license for any computer on which you install a Reporting Services server component (http://technet.microsoft.com/en-us/library/ms143238.aspx)." So the Microsoft solution is to get Enterprise Edition.
However, I came accross this article by Jason Selburg which claims to allow you to build your own data driven subscriptions using Standard Edition: http://www.sqlservercentral.com/columnists/jselburg/datadrivensubscriptions.asp
Good luck,
Larry
|||Oops, found a more recent article by the same author:
http://www.sqlservercentral.com/columnists/jselburg/2824.asp
that appears to be much more robust.
Larry
|||Thank you for your reply. Aplogies for only responding now.
sqlReporting Services SQL 2005 x64 standard edition
Can reporting services be upgraded to include data driven subscriptions or must SQL server be upgraded to enterprise edition. Currently I am using SQL 2000 standard edition 32bit with reporting services and data driven subscription. Has the features been changed from 2000 to 2005?
Thanks
Francois
Hello Francois,
SQL Server Reporting Services 2005 is a part of SQL Server 2005 and Data Driven Subscriptions are part of 2005 Enterprise Edition(http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx). From Books On Line (BOL) "Server components require a SQL Server license. You must have a valid SQL Server license for any computer on which you install a Reporting Services server component (http://technet.microsoft.com/en-us/library/ms143238.aspx)." So the Microsoft solution is to get Enterprise Edition.
However, I came accross this article by Jason Selburg which claims to allow you to build your own data driven subscriptions using Standard Edition: http://www.sqlservercentral.com/columnists/jselburg/datadrivensubscriptions.asp
Good luck,
Larry
|||Oops, found a more recent article by the same author:
http://www.sqlservercentral.com/columnists/jselburg/2824.asp
that appears to be much more robust.
Larry
|||Thank you for your reply. Aplogies for only responding now.
Wednesday, March 21, 2012
Reporting Services on Win XP Pro x64
I just installed SQL 2005 Express with advanced tools on my Win XP Pro 64 bit edition. I expected reporting services to work but it appears as if it isn't configured. I use SQL 2005 Enterprise at work and there I used the Reporting Services Configuration Toole to configure and set up reporting services. However, this tool is not available with the current install.
When I installed, the installer warned that .NET 64-bit is registered and that it requires .NET 32-bit to install report server. Is there a special install I need to install report server for x64.
Thanks
Wentzel
When I installed, the installer warned that .NET 64-bit is registered and that it requires .NET 32-bit to install report server. Is there a special install I need to install report server for x64.
Thanks
Wentzel
You need to configure IIS to run in WOW64 mode, see http://msdn2.microsoft.com/en-us/library/ms143293.aspx.
Tuesday, February 21, 2012
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
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
Subscribe to:
Posts (Atom)