June 22, 2015 at 4:42 am
iam unable to connect to reporting server , services are running fine .Checked in logs and found
ERROR: Error initializing configuration from the database: Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
How to resolve this ..
June 22, 2015 at 6:40 am
also
An error occurred when invoking the authorization extension. (rsAuthorizationExtensionError) Get Online Help The creator of this fault did not specify a Reason.
June 22, 2015 at 8:05 am
Where does the report service run? same server/localhost? ist Shared Memory enabled?
June 22, 2015 at 8:54 am
the report runs in the same server and shared memory is enabled .
June 22, 2015 at 1:49 pm
Just to be clear: are the SSRS server and the Database Server hosting the ReportServer databases on the same machine? If not I would verify connectivity to the instance hosting the RS databases and the account used to connect to the RS databases. If that is in order you should be able to reconnect to the RS databases though RS Configuration Manager.
Joie Andrew
"Since 1982"
June 23, 2015 at 3:00 am
Yes the reporting server and the database engine is in the same machine and the domain account is having sysadmin and admin on the local as well as in sql ..
June 23, 2015 at 3:58 am
What happens when you go through the RS Configuration Manager and try re-setting up the connection to the RS databases (choosing an existing database)?
Joie Andrew
"Since 1982"
June 23, 2015 at 4:08 am
as it is configured to use the report server db ..
June 23, 2015 at 7:56 am
this is the information found in logs
e ERROR: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An error occurred when invoking the authorization extension. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AuthorizationExtensionException: An error occurred when invoking the authorization extension. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)
at Microsoft.ReportingServices.WebServer.ReportingService2010.GetPermissions(String ItemPath, String[]& Permissions)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.GetPermissions(String ItemPath)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.<>c__DisplayClass3e.<GetPermissions>b__3d()
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod()
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.GetPermissions(String itemPath)
at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath)
at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser()
at Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
library!ReportServer_0-2!2ce4!06/23/2015-01:11:49:: Call to GetSystemPermissionsAction().
library!ReportServer_0-2!1500!06/23/2015-01:12:34:: Call to GetPermissionsAction(/).
library!ReportServer_0-2!2ce4!06/23/2015-01:12:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AuthorizationExtensionException: , Microsoft.ReportingServices.Diagnostics.Utilities.AuthorizationExtensionException: An error occurred when invoking the authorization extension. ---> System.ServiceModel.FaultException`1[Microsoft.EnterpriseManagement.Common.SdkServiceNotInitializedException]: The creator of this fault did not specify a Reason. (Fault Detail is equal to Microsoft.EnterpriseManagement.Common.SdkServiceNotInitializedException: Sdk Service has not yet initialized. Please retry).
--- End of inner exception stack trace ---;
ui!ReportManager_0-1!2fe0!06/23/2015-01:12:49:: e ERROR: HTTP status code --> 200
November 10, 2023 at 5:09 pm
Hi All was this resolved as im facing same challange on our server
February 8, 2024 at 4:24 pm
This was removed by the editor as SPAM
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply