CA UIM (Nimsoft) installation - Microsoft SQL Server database permissions required

Document ID : KB000034395
Last Modified Date : 18/10/2018
Show Technical Document Details
Introduction:
What database permissions are required for the user to install CA (UIM) Nimsoft Server when the backend database is MS SQL Server?
 
Instructions:
Systems Administrator (SA)
sysadmin

Installation always required sysadmin privileges which can be lowered to dbo (database owner) role after installation / upgrade.

Your SA user should have permissions on the 'msdb' database (which is like the master/built in sys database), not just mapped to the NimsoftSLM db. The database user needs permission on msdb and tempdb instances as well as the 'Nimsoft SLM' database.

Windows Authentication
For Windows Authentication you must ensure that:

? The Windows Domain Administrator has permission to log on as a service on both the NMS server and the Nimsoft SLM database server. See Configuring User Rights at technet.microsoft.com/en-us/library/dd277404.aspx.

? SQL Server is configured to use Windows authentication. See also Create a Login at msdn.microsoft.com/en-us/library/aa337562.aspx.

Windows Authentication Mode Windows Authentication mode lets a user connect through a Microsoft Windows XP, Windows 2000, or Windows NT 4.0 user account. Windows Authentication means SQL Server achieves logon security integration with Windows by using the security attributes of a network user to control logon access. A user's network security attributes are established at network logon time and are validated by a Windows domain controller. When a network user tries to connect, SQL Server uses Windows-based facilities to determine the validated network user name. SQL Server then permits or denies logon access based on that network user name alone, without requiring separate logon credentials.