Do you have a question?

First Name:
Surname:
Email:
Phone:
Message:
Get Audio Code

Unable to Query server ...: Connection failed to remote server ...
Last Post 03 Jun 2013 10:21 AM by Steve Wranovsky. 3 Replies.
Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Not Resolved
Scott CUser is Offline
New Member
New Member
Posts:9

--
30 May 2013 03:22 PM  

I installed ClearCanvas about 2 years ago. (ImageServer 2.0, RIS 2.0 Workstation 2.0). It worked well for some time but a while ago I found that the Workstation application could no longer query any of "My Servers" on the ImageServer. The problem seems to be on the ImageServer side, as I can run another DICOM SCP utility there and the Workstation app can ping ("Verify") that one ok but not any of the ClearCanvas ImageServer hosted Servers, with one exception: the first one I ever created - on port 104. So I wonder if maybe the others' configurations got messed up in my Workstation? To check what their settings should be I tried to log into my ImageServer as admin, but I receive the error message ... Login failed for user 'sa'.  ... (full message below), which is odd since I am not logging in as 'sa'. (very confusing...)

On the server, all 3 shred services are running;SQL server (MSSQLSERVER and SQLEXPRESS) services are running and the corresponding Agent services are set to automatic (delayed start),SQL Server Browser service is running and SQL Server VSS Writer service is running.

Any suggestions as to what else I should check?

Full Error Message:

 

Server Error in '/ImageServer' Application.

Login failed for user 'sa'. 

 


Version Information: Microsoft .NET Framework Version:2.0.50727.4234; ASP.NET Version:2.0.50727.4209

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'sa'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


            <pre>
[SqlException (0x80131904): Login failed for user 'sa'.]
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +578
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +84
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +1649271
   System.Data.SqlClient.SqlConnection.Open() +258
   ClearCanvas.ImageServer.Enterprise.SqlServer2005.PersistentStore.OpenConnection() +925
   ClearCanvas.ImageServer.Enterprise.SqlServer2005.PersistentStore.OpenReadContext() +44

[PersistenceException: Unexpected exception opening database connection for reading]
   ClearCanvas.ImageServer.Enterprise.SqlServer2005.PersistentStore.OpenReadContext() +256
   ClearCanvas.ImageServer.Web.Common.HttpContextData.get_ReadContext() +75
   ClearCanvas.ImageServer.Web.Common.Data.BaseAdaptor`4.Get(TCriteria criteria) +28
   ClearCanvas.ImageServer.Web.Common.Data.ServerPartitionConfigController.GetAllPartitions() +82
   ClearCanvas.ImageServer.Web.Application.Controls.ServerPartitionTabs.get_ServerPartitionList() +39
   ClearCanvas.ImageServer.Web.Application.Controls.ServerPartitionTabs.SetupLoadPartitionTabs(GetTabPanel tabDelegate) +43
   ClearCanvas.ImageServer.Web.Application.Pages.Studies.Default.OnInit(EventArgs e) +119
   System.Web.UI.Control.InitRecursive(Control namingContainer) +143
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1477
</pre>
            

 

johnUser is Offline
Basic Member
Basic Member
Posts:333

--
30 May 2013 03:35 PM  
Nice post. To see that the shredhost service is running is sometimes not enough. It may have been running the whole time, but at some point, the network connection to SQL server was dropped or SQL did not respond in time. That connection may have been restored since, but it's just not going to work right again without restarting the shredhost service.

You should check the ImageServer log after a restart of the service to make sure it starts up and does not complain about SQL Exceptions or login failures.

John
Scott CUser is Offline
New Member
New Member
Posts:9

--
30 May 2013 03:53 PM  
From the Workstation app I tried to Stop and then tried to Restart the Services. Both attempts failed so I checked the log. Not sure what it means but it doesn't look good. Can you decode for me? :-)

Failed to stop service 'ClearCanvas Workstation Shred Host Service'.
System.InvalidOperationException: Cannot open ClearCanvas Workstation Shred Host Service service on computer '.'. ---> System.ComponentModel.Win32Exception: Access is denied
--- End of inner exception stack trace ---
at System.ServiceProcess.ServiceController.GetServiceHandle(Int32 desiredAccess)
at System.ServiceProcess.ServiceController.Stop()
at ClearCanvas.ImageViewer.Services.Tools.ServiceControlTool.StopServiceInternal()
2013-05-30 15:46:01,385 [1] INFO - Exception thrown

Failed to restart service 'ClearCanvas Workstation Shred Host Service'.
System.InvalidOperationException: Cannot open ClearCanvas Workstation Shred Host Service service on computer '.'. ---> System.ComponentModel.Win32Exception: Access is denied
--- End of inner exception stack trace ---
at System.ServiceProcess.ServiceController.GetServiceHandle(Int32 desiredAccess)
at System.ServiceProcess.ServiceController.Stop()
at ClearCanvas.ImageViewer.Services.Tools.ServiceControlTool.RestartServiceInternal()
2013-05-30 15:46:12,400 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
2013-05-30 15:46:12,478 [1] WARN - Configuration store not found - defaulting to LocalFileSettingsProvider
Steve WranovskyUser is Offline
Veteran Member
Veteran Member
Posts:2107

--
03 Jun 2013 10:21 AM  
Were you running the Workstation app as an "administrator"? If not, it may be that the application didn't have permissions to start/stop the service on Windows, which would lead to the error you posted.
You are not authorized to post a reply.

Active Forums 4.1