Microsoft SQL Server

CA UIM supports only the full licensed product version with database authentication or Windows authentication for production environments. To obtain a copy of Microsoft SQL Server, go to www.microsoft.com/sqlserver and follow the installation instructions available with the download. 
uim902-9-0-2
CA UIM supports only the full licensed product version with database authentication or Windows authentication for production environments. To obtain a copy of Microsoft SQL Server, go to www.microsoft.com/sqlserver and follow the installation instructions available with the download. 
Microsoft SQL Server is only supported for Windows UIM server installations.
Both the Enterprise and Standard Editions of Microsoft SQL Server are supported with CA UIM. However, we generally recommend that you use the Enterprise Edition. CA UIM supports Always On availability groups for SQL Server high availability and disaster recovery.
Review the following information in this section:
 
 
2
 
2
 
 
Considerations
When installing Microsoft SQL Server, the simplest solution is to:
  • Accept the default instance name when you install Microsoft SQL Server
  • Use the default port (1433) when you install CA UIM
  • Run the installer as the domain logon user to be associated with the UIM Server installation.
Collations in Microsoft SQL Server provide sorting rules, case, and accent sensitivity properties for your data. Ensure that the collate option for the case is set to CI (Case Insensitive) for the UIM application. 
Other solutions have different requirements. If you:
  •  
    Use a non-default instance name for the Microsoft SQL Server:
     Use the default port (1433) when installing CA UIM.
  •  
    Use a port other than 1433 for CA UIM:
     Use the default Microsoft SQL Server instance name. 
During UIM server installation, you can select one of the following authentication options:
  •  
    SQL Server with SQL Server login
    : Provide the SQL Server user name and password during installation. No modifications are needed. 
  •  
    SQL Server with Windows authentication
    : You might need to make database modifications in advance, as described in the next section.
The following limitations are applicable for the Standard Edition of Microsoft SQL Server:
  • Table partitioning is not supported in the Standard Edition of Microsoft SQL Server. Therefore, the data maintenance jobs and the index maintenance jobs, which are scheduled from the data_engine probe UI, will not be effective because of the unsupported version.
  • During the scheduled data maintenance job, the data is deleted in batches based on the values set in the data_engine configuration file. Ensure that enough space is available on the drive where the transaction log file is located to avoid space issues.
  • During the table maintenance and the index maintenance, you must use the offline option in the data_engine UI before scheduling the index maintenance. The online index maintenance is not supported in the Standard Edition of Microsoft SQL Server.
Requirements for Windows Authentication
If you are also using Windows Authentication, review the following points:
  • The database access account must be a domain account.
  • The database access account must be in the Windows local administrators group on the UIM, UMP, and CABI servers.
  • The database access account must have sysadmin SQL permission on the MS SQL server during the installation (for database creation). Then, it fall backs to dbo to the CA_UIM database.
  • Add the
     Log on as a Service
     permission on both the CA UIM system (UIM/UMP/CABI servers) and the database system. For instructions, go to http://technet.microsoft.com/en-us/library/dd277404.aspx. 
  • Run the “Nimsoft Robot Watcher” service with the database access account.
  • To configure SQL Server to use Windows authentication, see http://msdn.microsoft.com/en-us/library/aa337562.aspx. 
 The user installing CA UIM must have the same administrative rights that were used to install the SQL Server. Specifically, the data_engine probe must have identical administrative rights on both the CA UIM system and the database system. These credentials are supplied during installation.
Manual Creation of the Database Schema and User
Manually create the Microsoft SQL Server database schema and user.
 
Follow these steps:
 
  1. Log in to SQL Server Management Studio as the system administrator (sa).
  2. Execute the following commands individually:
    CREATE DATABASE <UIM_db_name>; USE <UIM_db_name>; CREATE LOGIN <UIM_db_user> with PASSWORD = '<UIM_db_password>', DEFAULT_DATABASE = <UIM_db_name>; CREATE USER <UIM_db_user> FOR LOGIN <UIM_db_user>; EXEC sp_addrolemember 'db_owner', <UIM_db_user>; EXEC sp_addmessage @msgnum = 55000, @severity = 16, @msgtext = N'%', @replace = 'replace', @lang = 'us_english';