CA SDM 17.1 installation against MS SQL Server over a non default SQL port fails

book

Article ID: 107651

calendar_today

Updated On:

Products

CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Some customer installations disable the MS SQL Browser service and configure SQL Server to use non default ports, like 3369, as opposed to the default 1433 port. CA Service Desk Manager (SDM) 17.1 installation against such an installation fails with an error "Unable to create the mdbadmin user"


Install logs show: 
Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Named Pipes Provider: Could not open a connection to SQL Server [5]. . 

2018/07/10 13.10.26.156 DEBUG [DeployThread: Configuring CA Service Management common tables] [InstallCDB] Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Login timeout expired. 

2018/07/10 13.10.26.156 DEBUG [DeployThread: Configuring CA Service Management common tables] [InstallCDB] Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.. 

2018/07/10 13.10.26.156 INFO [DeployThread: Configuring CA Service Management common tables] [ActiveProcessHolder] Exit Monitor. Process ID (PID): 2424 
2018/07/10 13.10.26.156 DEBUG [DeployThread: Configuring CA Service Management common tables] [InstallCDB] Failed to create mdbadmin user 
2018/07/10 13.10.26.156 DEBUG [DeployThread: Configuring CA Service Management common tables] [InstallCDB] Failed to create mdbadmin user (mdbadmin) for Database Name (mdb) in (RealSDMHostName) Database. 
2018/07/10 13.10.26.156 ERROR [DeployThread: Configuring CA Service Management common tables] [InstallCDB] Creation of mdbadmin user failed. 


CA Service Desk Manager (SDM) 17.1 installation against MS SQL Server over a non default SQL port fails with an error "Unable to create the mdbadmin user"
 

Environment

SDM 17.1 on MS SQL Server on a non default port

Resolution

First:
1) on SDM node, invoke SQL Server Configuration Manager 
2) SQL Native Client 11.0 configuration (32bit) - Client Protocols - TCPIP -> right click on TCPIP and select properties -> Change the value of the Default port (example: 3369) to the SQL Server port that the remote SQL Server database uses. Click OK 
3) Repeat the same to SQL Native Client 11 configuration (this is the 64bit one) 

Second: 
1) SQL Native Client 11.0 configuration (32bit) - Aliases - Right click on the right pane and select New Alias 
2) Alias Name = <SQL Server Host Name>, Port No = <SQL Server port number (3369)>, Server = <SQL Server Host Name>
3) Click OK 
4) Repeat 1, 2, 3 but this time for SQL Native Client 11.0 configuration (this is the 64bit one) 

Third: 
1) Restart SM Installer fully. 
2) On Database Configuration window - fill in the correct port # for SQL Server (example: 3369), fill in other details BUT do NOT fill in the Instance Name. The Database Server should have the value of your Database Alias created in SECOND phase above.
3) Complete the details on rest of the screens and now the installer should be successful. 

 

Additional Information

The above steps to create SQL Alias is not needed on Catalog box, because Catalog uses JDBC. 

CA Engineering team is still researching this case via defect DE42550