32-bit Reporting service + 64-bit SQL Server 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

32-bit Reporting service + 64-bit SQL Server 2005

Author

Topic

ghzpc
Starting Member

2 Posts

Posted - 2009-06-17 : 03:54:31

Helo,

I'm building an intranet application with ASP.NET 2.0. Now i want to use reporting services 2005 for my reports.

On our Windows 2003 R3 64-bit server there's already an SQL Server 2005 64-bit installed.
IIS 6 is configured to run 32-bit Applications on 64-bit Windows (Enable32BitAppOnWin64 =true).

First i installed the 64-bit Reporting Services, but when calling the report manager (http://localhost/reports) i get an error
that IIS is running in 32-bit mode and the Reporting Services on an 64-bit mode.
The error was 'Attempted to load a 64-bit assembly on a 32-bit platform. Use ReflectionOnlyLoad() instead...'

So i uninstalled the 64-bit Reporting Services, and I installed the 32-bit reporting services using the package 'SQL Server 2005 Express Edition with Advanced Services'.

Now i receive an error when opening the reportserver (http://localhost/reportserver):
"The feature: "The Database Engine instance you selected is not valid for this edition of Reporting Services. The Database Engine does not meet edition requirements for report data sources or the report server database. " is not supported in this edition of Reporting Services. (rsOperationNotSupported)".

Below some information of the Report Server log:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>Romance Daylight Time</TimeZone>
<Path>C:\Program Files (x86)\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\ReportServer__06_16_2009_14_44_49.log</Path>
<SystemName>SERVERNAME</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
<OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!webserver!8!16/06/2009-14:44:49:: i INFO: Reporting Web Server started
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!8!16/06/2009-14:44:49:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!8!16/06/2009-14:44:49:: i INFO: Reporting Services starting SKU: Express
w3wp!resourceutilities!8!16/06/2009-14:44:49:: i INFO: Evaluation copy: 0 days left
w3wp!resourceutilities!8!16/06/2009-14:44:49:: i INFO: Running on 4 physical processors, 8 logical processors
w3wp!runningjobs!8!16/06/2009-14:44:49:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!8!16/06/2009-14:44:49:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!8!16/06/2009-14:44:49:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!8!16/06/2009-14:44:49:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!7!06/16/2009-14:44:49:: Call to GetItemTypeAction(/).
w3wp!library!7!06/16/2009-14:44:49:: i INFO: Catalog SQL Server Edition = Standard
w3wp!library!7!06/16/2009-14:44:49:: e ERROR: required SKUs: Express - actual SKU Standard
w3wp!library!7!06/16/2009-14:44:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "The Database Engine instance you selected is not valid for this edition of Reporting Services. The Database Engine does not meet edition requirements for report data sources or the report server database. " is not supported in this edition of Reporting Services., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "The Database Engine instance you selected is not valid for this edition of Reporting Services. The Database Engine does not meet edition requirements for report data sources or the report server database. " is not supported in this edition of Reporting Services.w3wp!library!8!06/16/2009-14:44:50:: Call to GetPermissionsAction(/).

How can i fix this problem?
w3wp!library!8!06/16/2009-14:44:50:: i INFO: Catalog SQL Server Edition = Standard
w3wp!library!8!06/16/2009-14:44:50:: e ERROR: required SKUs: Express - actual SKU Standard
w3wp!library!8!06/16/2009-14:44:50:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "The Database Engine instance you selected is not valid for this edition of Reporting Services. The Database Engine does not meet edition requirements for report data sources or the report server database. " is not supported in this edition of Reporting Services., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "The Database Engine instance you selected is not valid for this edition of Reporting Services. The Database Engine does not meet edition requirements for report data sources or the report server database. " is not supported in this edition of Reporting Services.
w3wp!webserver!6!16/06/2009-14:45:04:: i INFO: Reporting Web Server stopped

gedwards
Starting Member

19 Posts

Posted - 2009-06-18 : 08:53:35

We run reporting services on an x64 bit server with IIS in 64 bit mode. IIs on W2003 from what I recall can run either in 32 bit or 64 bit mode, but not both.
Hopefully you can remove your last install of RS cleanly.
I'd try reinstalling the 64 bit version and make sure IIS is in 64 bit mode.
Unless you are running other apps on IIS, I wouldn't see any need for 32 bit.
Greg E

Greg E

Cody
Starting Member

24 Posts

Posted - 2009-06-18 : 21:00:45

I'm fairly certain I've read elsewhere that you can't mix editions of reporting services. If you use SQL 2005 Express SSRS, then the SSRS database MUST be stored on an SQL 2005 Express server. Same for 2008.

For your setup there is nothing to stop you from installing SQL 2005 Express and SSRS together beside your existing SQL x64 installation, and using Express for your SSRS database the x64 as the data source for your reports.

Alternatively I don't know much about IIS but maybe you can use an x64 version so you can use x64 SQL and SSRS? Annoying but that's life.

ghzpc
Starting Member

2 Posts

Posted - 2009-06-22 : 12:33:21

I installed the evaluation edition of the reporting services. It works without any problem.

@Cody: you're right. SQL 2005 Express SSRS can only connect to a SQL 2005 Express SSRS database.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources