asked on

Loading SQL Reporting Services on Windows Server 2008

Background:
I've set up our new server with Windows Server 2008 (x64), Windows Exchange Server 2007 (x64), and Windows SQL Server 2005. All appear to be running correctly. Now I am trying to load Microsoft Dynamics CRM 4.0 and was prompted to load SQL Reporting Services. When I did, I recieved a warning error "IIS is either not installed or not configured for server component installation". But I was allowed to continue. During the installation, the SQL Instance does not appear in the pulldown, but I was able to type it in and a sample database was installed. However, the Reporting Services does not appear to be installed and running.
Questions:
Am I missing an important configuration step?
Can I run Reporting Services 2000 SP 2 in a Server 08 (x64) environment?
Does anyone have any ideas?

ASKER CERTIFIED SOLUTION

jkarnes12

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

utahspc

ASKER

Yes, I did enable the IIS Role before loading Report Services. My copy of SQL 2005 does not contain the Report Services. I installed it from a seperate disc. It appears to be SQL Report Services 2000 SP 2. I also downloaded SQL Report Services from the Microsoft website and it appears to be the same version.

jkarnes12

Which Version of SQL2005 do you have? Report Services is included with SQL 2005 Standard, Ent, Datacenter...

utahspc

ASKER

When using the autorun wizard, the Report Services was unavailable. However, I did find it by searching the directory. Now I have everything installed and the service is running, but I am still getting stopped in the CRM installation. There is an error under Sequel Reporting Services
Setup Failed To Validate Specified Reporting Services Report Server http://utahspcserver/reportserver. Error: The request failed with Http status 503:service unavailable

utahspc

ASKER

Ok, I've almost got it. I'm now getting an error when I load the report server from a web page. I found this Question from some one with the same problem, but there was no resolution; https://www.experts-exchange.com/questions/23279852/MS-Dynamics-CRM-4-0-Setup-check-fails-ReportServer-issues.html

other internet sites sugest that this error can be solved through the .net security setings; however, I haven't been able to solve it yet.

Server Error in '/ReportServer' Application.
--------------------------------------------------------------------------------
 
Configuration Error 
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. 
 
Parser Error Message: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. An attempt was made to load a program with an incorrect format.
 
Source Error: 
 
 
Line 27:       <assemblies>
Line 28:         <clear />
Line 29:         <add assembly="ReportingServicesWebServer" />
Line 30:       </assemblies>
Line 31:     </compilation>
 
 
Source File: C:\Program Files (x86)\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config    Line: 29 
 
Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.
 
 
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
 
 
 
 
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1434; ASP.NET Version:2.0.50727.1434

Open in new window