Tag: "iis"

Reporting Services 2005 on Windows Server 2008 (+ Vista) or Windows 2008 R2 (+ Windows 7) - IIS configuration

Many still use SQL Server/Reporting Services 2005 although sometimes alread on Windows Server 2008 / Vista / Windows 7.

I absolutely do recommend upgrading to SQL Server 2008. There are many advantages in the combination - be it security or performance (Security, Performance, No need for IIS) - but if you can't uprade right now, you do need to install IIS for Reporting Services 2005 to run.

I have seen recommendations (even on a Microsoft blog) where they tell you to install EVERY Role Service for IIS - but that is untrue and against basic security principles.

I always always recommend "install as little as possible, but just as much as required".

You do not need an FTP-Server to run Reporting Services! - Natural to most. But when it comes to less known features like, CGI , SSI, Tracing..?.. most aren't so sure.

So here is the definite list of required role services for IIS. I tried to leave of everything I could, and this turned out:

 

Web Server
  Common HTTP Features
     Static Content
     Default Document
     HTTP Errors
     HTTP Redirection
  Application Development
     ASP.NET
     .NET Extensibility
     ASP
     ISAPI Extensions
     ISAPI Filters
  Health and Diagnostics
     HTTP Logging
     Request Monitor
  Security
     Windows Authentication
     Request Filtering
  Performance
     Static Content Compression
  Management Tools
     IIS Management Console
     IIS 6 Management Compatibility
     IIS 6 Metabase Compatibility
     IIS 6 WMI Compatibility
     IIS 6 Scripting Tools
     IIS 6 Management Console

 

I also attach a cmd-file. This file will install all the required packages by itself. You do not need to don any IIS Installation beforehand. It's using the new Package Manager available on Windows Server 2008. Just remove the .txt after you checked it out ;-

If You are using Windows Server 2008 R2/Windows 7 with IIS 7,5, Package Manager is deprecated. Instead use Deployment Image Servicing and Management as described here: http://blogs.msdn.com/b/habibh/archive/2009/08/14/how-to-install-iis-7-5-on-windows-7-using-the-command-line.aspx

I also prepared a file using DISM, which you can download here.

For Some reason though the Packetmanager installs "Directory Browsing, which is NOT required (bull***) - you should remove it manually. This seems to be a bug with Package Manager.

At the end it should look like this:
IIS on Windows Server 2008 for Reporting Servives 2005

 

 IIS will be properly detected (and we know for sure, that "Directory Browsing" is not a requirement"):

 System_Configuration_Check_Sql_Server_2005_Setup_IIS_Reporting_Services

 

There is still something however:

After you installed and navigate to http://YourServername/Reports

You will get an error: "unable to connect to remote server"

when checking the Logfile  "ReportServerWebApp" it says:

 

w3wp!ui!7!22.10.2008-10:24:47:: e ERROR: Unable to connect to the remote server
w3wp!ui!7!22.10.2008-10:24:47:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:443
   at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
   at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
   at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
   --- End of inner exception stack trace ---

 

Solution:

In IIS 7 Manager, highlight the ReportServer application (Not "Reports")

go to Handler Mappings, click "Edit Feature Permissions" in the "Actions Pane", and enable "Script and Execute".

IIS_Manager_Handler_Mapping_for_Reporting_Services_2005

 

You are all set - it should be running just fine now.

Everything described here also applies for running Reporting Services 2005 on Windows Vista (SP1).

Download to IIS 7 Setup-File using Package Manager (rename to .cmd or .bat)

Download to IIS 7.5 Setup-File using DISM (rename to .cmd or .bat)

 

I also found a nice explaination of the IIS-Setup here: http://learn.iis.net/page.aspx/130/understanding-setup-in-iis-7/  

 

Andreas Wolter Training & Consulting

Reporting Services 2005 x64 Fehlermeldungen bei der Installation unter Windows Server - mit Lösungen

bei der Einrichtung von Reporting Services 2005 Version x64 traten in der Reihenfolge folgende Fehler auf, zu welchen ich die Lösungen hier gerne hinterlegen möchte:

1)

"The virtual directory could not be created. The previously set virtual directory will still be used."

Details: "System.IO.FileNotFoundException:
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.CreateVirtualDirectory(String virtualDirectory, String path)"

 

Lösung:

das lag daran, das  ASP.Net VOR dem .Net Framework 2.0 installiert war

(meine Quelle: http://www.bokebb.com/dev/english/2027/posts/2027133704.shtml )

Nach einer Reparatur-Installation des .Net Framework 2.0 lief es tadellos.

 

 2)

Als nächstes kam folgende Fehlermeldung auf der Website http://Servername/Reports:

"The ReportServerVirtualDirectory element is missing"

Lösung:

in der Datei RSWebApplication.config im Verzeichnis "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager"

im Knoten <ReportServerVirtualDirectory></ReportServerVirtualDirectory> den Servernamen wie folgt eintragen:

<ReportServerUrl>http://ServerName/Reportserver</ReportServerUrl>

 

3)

 Es folgte ein HTTP: 500 Fehler "The request failed with HTTP status 503: Service Unavailable."

 Lösung:

 iisreset in der Kommandozeile

 

so, ich hoffe das hilft dem Nächsten, etwas Zeit zu sparen

 

Andreas Wolter Training & Consulting