privileges required for the Database Admin User to avoid using SA during SDM installation or upgrade
search cancel

privileges required for the Database Admin User to avoid using SA during SDM installation or upgrade

book

Article ID: 399760

calendar_today

Updated On:

Products

CA Service Management - Service Desk Manager CA Service Catalog CA Service Desk Manager

Issue/Introduction

DBA can't share the SA password due to company restrictions. What are the privileges required for a successful upgrade/installation of Service Management?

Environment

Service Management 17.x

SQL Server

Resolution

You can create or use an alternative admin account with "sysadmin" and "public" role privileges.

Refer to the SQL Server documentation for the creation of this user in the link below:

Admin Account - Alternative to "sa" account?

Additional Information