Cannot activate the Manager for SQL Server

book

Article ID: 128467

calendar_today

Updated On:

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'"

Cause

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

Environment

Dollar Universe 6 on Windows

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