On non english (aka localized) versions of Windows Essential Business Server (EBS) the SCE Reports seems to fail after installation of the SCE Servicepack 1 (SCE SP1) which came a few weeks ago.
The detailed error message on a german system is like this:
“
Datum: 11.03.2009 19:17:45
Anwendung: System Center Essentials
Anwendungsversion: 6.0.1885.0
Schweregrad: Fehler
Meldung: Bericht konnte nicht initialisiert werden.
System.Net.WebException: Die Verbindung mit dem Remoteserver kann nicht hergestellt werden. ---> System.Net.Sockets.SocketException: Es konnte keine Verbindung hergestellt werden, da der Zielcomputer die Verbindung verweigerte ::1:443
bei System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
bei System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
bei System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
--- Ende der internen Ausnahmestapelüberwachung ---
bei System.Net.HttpWebRequest.GetRequestStream()
bei System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
bei Microsoft.SqlServer.ReportingServices2005.Execution.ReportExecutionService.ListSecureMethods()
bei Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods()
bei Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname)
bei Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname)
bei Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID)
bei Microsoft.Reporting.WinForms.ServerReport.GetExecutionInfo()
bei Microsoft.Reporting.WinForms.ServerReport.GetParameters()
bei Microsoft.EnterpriseManagement.Mom.Internal.UI.Reporting.Parameters.ReportParameterBlock.Initialize(ServerReport serverReport)
bei Microsoft.EnterpriseManagement.Mom.Internal.UI.Console.ReportForm.SetReportJob(Object sender, ConsoleJobEventArgs args)
System.Net.Sockets.SocketException: Es konnte keine Verbindung hergestellt werden, da der Zielcomputer die Verbindung verweigerte ::1:443
bei System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
bei System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
bei System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
”
There is a hotfix available for english systems only, the localized fix will be published maybe next month:
957755 The reporting functionality in System Center Essentials 2007 Service Pack 1 stops working after you apply security update 948109 on the Windows Essential Business Server Management Server
Because there is no localized hotfix by now you need to use the manual steps shown in the KB to fix the System Center Essentials Reports in EBS after SCE SP1 got deployed on non EN systems:
- On Windows Essential Business Server Management Server, open an (elevated) command prompt.
- Run the following (in bold) command at the command line window:
%SystemRoot%\System32\inetsrv\appcmd.exe set config "Default Web Site/ReportServer$SCE" /section:handlers /accessPolicy:Read,Script
- After the command in step 2 is complete, run the following command at the command line window:
%SystemRoot%\System32\Icacls.exe "%PROGRAMFILES(X86)%\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\rsreportserver.config" /grant *S-1-5-20:F