A network-related or instance specific error while accessing Server Manager or any service through ACMO.

A network-related or instance specific error while accessing Server Manager or any service through ACMO.

Issue
If you are getting the error while accessing server manager or accessing any service through ACMO.


Resolution

Just enable the Web Service DT for Database (Server Manager) from the Admin Settings page to resolve the error for Server Manager

To resolve the error for accessing any service enable  Web Service DT for Database (ARCOS Clients).


If you are not able to access Admin Setting you can run the below queries to do the changes from the Database.

For Server Manager

Use the below queries to check if the aps_id is correct or not


select * from sso_arcos_Config where aps_id=53; or select * from sso_arcos_Config where aps_description like where ‘%DT%’;


Run the below query to change the setting

Update sso_arcos_config set aps_defaultvalue=1 where aps_id=53;

For ACMO Service Error

Use the below queries to check if the aps_id is correct or not


select * from sso_arcos_Config where aps_id=89; or select * from sso_arcos_Config where aps_description like where ‘%DT%’;


Run the below query to change the setting


Update sso_arcos_config set aps_defaultvalue=1 where aps_id=89;

Take a "iisreset" on the Database Server by opening Command Prompt using Administrator Priviledges

If this also doesn’t resolve the error

Open SQL Server Configuration Manager

Expand SQL Server Network Configuration > Select Protocols for <Instance Name>.

Check if all the Protocol status is enabled or not.

Restart the SQL server instance from SQL Server Services or Services.msc Application.