Friday, March 23, 2012

Reporting Services on XP Professional

Is it possible to install reporting services on SQL Server 2000 on XP Professional?

When I try this I get errors: "ASP.NET is not installed or not registered with your Web Server" and "This version of reporting services does not support installing the server components on this operating system"

ASP.NET is installed and registered with IIS. I can publish pages written with Visual Web Developer Express which work fine.

What version of reporting services do I need to be able to install on XP-Pro?

Did you try the latest service pack? And are you running SQL Server Developer Edition?|||

I have now installed SQL Server 2005 Express with advanced services. I can create reports, preview them but cannot view them in Internet Explorer. Is this a limitation of the Express edition?

I get the following error:

  • An error has occurred during report processing. (rsProcessingAborted)
  • Cannot create a connection to data source 'ProfileMES'. (rsErrorOpeningConnection)
  • An internal error occurred on the report server. See the error log for more details. (rsInternalError)|||Installing the SQL Server 2000 reporting services require fixed steps, you need the developer edition ignore any questions Windows ask you unless it is relevant to you. Download and install service pack 3 and 3a these are 25 .sql files Windows uses as needed I have used them with all current operating systems, ran into minor problems with Win2k standard server. The next step is very important install the reporting service and you can install it. If it ask for service pack 4 you have to install that too but I installed it a while back. The most important thing is installing the service packs before installing reporting service and don't answer Windows questions. The SQL Server team have cleaned up the Windows questions in 2005 so it is much easier to install. Hope this helps.|||

    I found the problem with SQL Server Express: The data source must also be in the same SQL Express you cannot have data coming from any other remote source be it SQL Server, MS Access or whatever.

    Still don't no why Reporting services 2000 won't install under XP though. Nothing I try gets rid of the .NET/IIS error. I'll have to see if I can set up a clean machine and do an install from scratch.

    Keith

    sql
  • No comments:

    Post a Comment