Database error 10060 at CON

[Former Member]

Good day

Can anyoine assist please?

We have a Solution Manager 7.1 system with a number of managed systems connected. I believe that it was when the original installation was done, that a sandbox system was attached as a managed system.The sandbox system was subsequently decommissioned but never updated in the Solution Manager system. Anyway, we are getting the following in the system log:

3:48:58 DIA  002 001 SM_EFWK	BY  2 Database error 10060 at CON
3:48:58 DIA  002 001 SM_EFWK	BY  0 > TCP Provider: A connection attempt failed because the
3:48:58 DIA  002 001 SM_EFWK	E0  0 New System Log File Started with Number 1799
3:48:58 DIA  002 001 SM_EFWK	BY  0  connected party did not properly respond after a period of
3:48:58 DIA  002 001 SM_EFWK	BY  0 > time, or established connection failed because connected hos
3:48:58 DIA  002 001 SM_EFWK	BY  0 > has failed to respond.##
3:48:58 DIA  002 001 SM_EFWK	BY  1 Database error 10060

and in the work process trace file:

Fri Mar 11 13:12:57 2016

  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2518]

  (10060) [08001] [Microsoft][SQL Server Native Client 11.0]TCP Provider: A connection attempt failed because the connected party d

  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2518]

  (0) [HYT00] [Microsoft][SQL Server Native Client 11.0]Login timeout expired

  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2518]

  (10060) [08001] [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establi

  Connection 0 failed using Driver={SQL Server Native Client 11.0};Server=ZAPALSAPSB\PCS,61003;AutoTranslate=no;UID=PCS_SAPMonitor;

  ***LOG BY2=> sql error 10060      performing CON        [dbds         879]

  ***LOG BY0=> TCP Provider: A connection attempt failed because the connected party did not properly respond after a period of tim

[dbds         879]

  ***LOG BY1=> sql error 10060      [dbacds       1515]

In the Solution Manager system I removed the system as a managed system but still get these in the syslog.

Is there some other action that needs to be taken to get this connection attempt cancelled?

Regards

Ray Phillips

[patelyogesh]

Hello Raymond

If you have firewall can you make sure you have configured firewall to allow connections and also make sure SQL server accept remote connections.

Thanks

Yogesh

[Former Member]

Thanks for your reponse Yogesh. The problem is that the server and system have long been decommissioned so firewall is not relevant here.