Unable to update the databse IDs

• djj

  SSCoach

  Points: 18831

  More actions

  September 18, 2014 at 11:39 am

  #299595

  On a SQL2008R2 instance running on a Windows 2008R2 OS. I have blanked the IP address but would like to know if there is a way to find what is causing this?

  Is it a problem with the port 5201 not being setup?

  Unknown when this started but might be when the virtual was moved.

  Date9/18/2014 1:10:37 PM

  LogWindows NT (Application)

  SourceSQLcompliance Agent

  Category(0)

  Event29001

  ComputerMyServer.MyDomain.local

  Message

  Unable to update the database IDs for MyServer\MyInstance

  Error: System.Net.Sockets.Socket

  Exception: A connection attempt failed because the connected party did not properly respond after a period of time,

  or established connection failed because connected host has failed to respond xxx.xxx.x.xx:5201

  Server stack trace:

  at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)

  at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)

  at System.Runtime.Remoting.Channels.RemoteConnection.CreateNewSocket(EndPoint ipEndPoint)

  at System.Runtime.Remoting.Channels.RemoteConnection.CreateNewSocket()

  at System.Runtime.Remoting.Channels.SocketCache.GetSocket(String machinePortAndSid, Boolean openNew)

  at System.Runtime.Remoting.Channels.Tcp.TcpClientTransportSink.SendRequestWithRetry(IMessage msg,

  ITransportHeaders requestHeaders, Stream requestStream)

  at System.Runtime.Remoting.Channels.Tcp.TcpClientTransportSink.ProcessMessage(IMessage msg,

  ITransportHeaders requestHeaders, Stream requestStream,

  ITransportHeaders& responseHeaders, Stream& responseStream)

  at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg)

  Exception rethrown at [0]:

  at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)

  at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

  at Idera.SQLcompliance.Core.Event.RemoteAuditManager.UpdateDBIds(Hashtable auditedServerDbIds, String instance)

  at Idera.SQLcompliance.Core.Agent.SQLcomplianceAgent.UpdateDBIds(Hashtable auditedServerDbIds, String instance)

  at Idera.SQLcompliance.Core.Agent.SQLInstance.SyncDBIds()