(SQL SERVER) a database connection object the "Test Connection" returns error U2012064

Article Id: 84397

Status: Published

Updated On: 15-04-2018 08:01

Legacy Id: 000013791

Products:

CA Automic Workload Automation - Automation Engine , AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction:

Error Message :
U2012064 - Connection Refused.

A new connection object is created. Upon clicking on 'Test Connection', an error message is returned.

Cause:

Cause type:
Configuration
Root Cause: The TCP/IP Protocol for MS SQL Server is not Enabled.

Environment:

Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:

Resolution:

1. Start the SQL Server Configuration Manager.
2. Select SQL Server Network Configuration.
3. Right Click TCP/IP and choose Enable.
4. Open Services.msi.
5. Restart your applicable core SQL Server Service.

Fix Status: No Fix