Cannot activate the Manager for SQL Server

Products

• CA Automic Dollar Universe

Issue/Introduction

The error "Database connection verification was not successful" when trying to activate the Manager for SQL Server in Dollar Universe superior to 6.2.x
The error that appears is "login failed for user 'domain\username'"

Environment

Dollar Universe 6 on Windows

Cause

The Dollar Universe Manager for SQL Server only support Internal Microsoft SQL Server Users.
 

Resolution

You need to use a SQL Server Internal User to use the Manager for SQL Server.
Extract from the documentation:
 

• Login/Password: Provide a valid SQL Server account and password.

To connect to the SQL Server instance, the Manager uses an SQL existing account (user and password). The SQL login must be associated with the public and sysadmin roles. The sysadmin role is required to be able to manage SQL jobs.

The Manager system account does not have an impact on the connection.

Additional Information

https://docs.automic.com/documentation/webhelp/english/ALL/components/DU_AS/latest/%20%20Dollar%20Universe%20Guides/help.htm#MSQHelp/msq_sqlserverconnectionnodesettings.htm%3FTocPath%3DManager%2520for%2520Microsoft%2520SQL%2520Server%7CConfiguring%2520the%2520Manager%2520for%2520Microsoft%2520SQL%2520Server%7CManager%2520for%2520Microsoft%2520SQL%2520Server%2520Settings%7C_____2