IBM® Content Manager OnDemand is designed to work with variety of database engines including Microsoft SQL Server. This document addresses the installation and configuration issues of Microsoft SQL Server for Content Manager OnDemand. It applies to SQL Server 2014, 2016, 2017 and 2019.
Microsoft SQL Server 2014 requires Microsoft .NET Framework 3.5.1 to be installed. On Windows 2012 R2 server, this step is not performed by the SQL Server 2014 installation process. This can be done by using the Windows 2012 R2 Server Manager prior to the SQL Server 2014 installation. In the Server Manager interface, select Features on the left panel and select .NET Framework 3.5.1 from the list. One may need to click Add Features on the right panel if .NET Framework 3.5.1 is not shown. Follow the screen directions to install the feature and reboot as instructed.
For all SQL Server versions
To install Microsoft SQL Server, click setup.exe to launch the SQL Server Installation Center. Select Installation on the left panel. Select New SQL Server standalone installation or add features to an existing installation on the right panel. Make sure there are no failures on the following Setup Support Rules panels.
On the Setup Role panel, choose SQL Server Feature Installation. On the Feature Selection screen, select Database Engine Services and Client Tools Connectivity. Make sure there are no failures on the Installation Rules panel.
On the instance Configuration panel, choose Default instance.
On the Database Engine Configuration panel, choose Mixed Mode (SQL Server authentication and Windows authentication) and specify a password for the SQL server admin ID, sa. The Mixed Mode authentication is needed to create a new SQL Server user ID later to be used by the Content Manager OnDemand instance owner. Click Add Current User to also add the logged on Windows user ID to the SQL Server. Click Next to Continue as instructed. Make sure there are no failures on the Installation Configuration Rules panel.
When the SQL Server installation completes, make sure there are no errors, close the SQL Server Installation Center and reboot the server if required.
Installing Microsoft SQL Server Management Studio (SSMS)
For Content Manager OnDemand V10.1, you need to install SQL Server Management Studio 17.9.1 which can be found in the link below.
For Content Manager OnDemand V10.5, you should install the latest version of SQL Server Management Studio, such as 18.6. As of this writing, the latest version of SQL Server Management Studio can be found in the link below.
After the SQL Server Management Studio is successfully installed, launch SSMS and connect to Database Engine. Click Security and expand Logins on the left panel. Note the Windows user ID used to install SQL Server is listed but in the form of <domain_name>\user_name. We need to create a new SQL Server login without the host name or domain name. Right click Logins and select New Login... Enter the name of an existing Windows user ID with administrator rights, such as odadmin. This is the user ID that will be used to create the Content Manager OnDemand instance. Select SQL Server Authentication and enter a password for the new SQL Server user ID. Accept the default database name master. On the Server Roles page, make sure the dbcreator box is checked. Click OK to create the new login.
Content Manager OnDemand V10.1 SMO Registration Verification
Make sure the SQL Server Management Studio 17.9.1 is installed. Install Content Manager OnDemand V10.1.0.0. At the end of the install, check to make sure the Content Manager OnDemand SMO module is registered by issuing the following command.
Content Manager OnDemand V10.5 SMO Registration Verification
Install Content Manager OnDemand V10.5.0.0 followed by V10.5.0.1. At the end of the install, check to make sure the Content Manager OnDemand SMO module is registered by issuing the following command.
Additional setup notes
See the attached document for additional notes and screen captures regarding SQL Server setup.
15 January 2021