CA Gen SQL Server DDL install (TIS95DDL.EXE) fails with "Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=12.0.0.0, ...' or one of its dependencies"

book

Article ID: 142381

calendar_today

Updated On:

Products

CA Gen CA Gen - Workstation Toolset

Issue/Introduction

Trying to install DDL generated for the CA Gen sample model into a SQL Server 2016 database GENDB which has been previously created and received this error in the Build Tool:
*****
...
Initial search for build executables
TIS95DDL.EXE

--- Found TIS95DDL.EXE


Database maintenance started

Unhandled Exception: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
   at SMOBridge.dbConnect(SMOBridge* , SByte* conn, SByte* usr, SByte* pwd)
   at dbConnect(SByte* conn, SByte* usr, SByte* pwd)
   at _mainCRTStartup()
IEFSIGNAL:FAIL
GENDB Error: Database Install Failed
*****

Cause

The root cause is that the required version of SQL Server Shared Management Objects (SMO) is not installed e.g.
https://support.timextender.com/hc/en-us/articles/210437663-Error-Could-not-load-file-or-assembly-Microsoft-SqlServer-ConnectionInfo-
https://social.msdn.microsoft.com/Forums/ie/en-US/896e04a7-d5b0-41bf-a846-eb69dc5cc06a/microsoftsqlserverconnectioninfo-load-error?forum=adodotnetdataproviders

Environment

Release : 8.6

Component : CA Gen Build Tool

Resolution

SQL Server Shared Management Objects "Version=12.0.0.0" is part of the SQL Server 2014 Feature Pack:
https://blog.sqlauthority.com/2018/05/11/sql-server-error-could-not-load-file-or-assembly-microsoft-sqlserver-management-sdk-sfc-version-12-0-0-0/

1. Go to Microsoft SQL Server 2014 Feature Pack page: https://www.microsoft.com/en-in/download/details.aspx?id=42295  

2a. If Build Tool Profile OPTIONS token OPT.BITS is set to default value of 32, the installer executable "%GEN86%\Gen\TIS95DDL.EXE" will be used. Download and install the x86 versions of SQLSysClrTypes.msi and SharedManagementObjects.msi.
b. If Build Tool Profile OPTIONS token OPT.BITS is set to 64, the installer executable "%GEN86%\Gen\AMD64\TIS95DDL.EXE" will be used. Download and install the x64 versions of SQLSysClrTypes.msi and SharedManagementObjects.msi.

Then the DDL install should be successful per below:
*****
--- Found TIS95DDL.EXE


Database maintenance started

TIS95DDL: CA Gen SQLServer DDL Installer
TIS95DDL: Copyright (C) 2016 CA. All rights reserved.
TIS95DDL: All rights reserved.

TIS95DDL: Connection="Server_instance", User="sa", Password="***********"

TIS95DDL: Database GENDB Used
TIS95DDL: Table DEPARTMENT Created
TIS95DDL: Table DIVISION Created
TIS95DDL: Table EMPLOYEE Created
TIS95DDL: Table PROJECT Created
TIS95DDL: Table TEAM Created
TIS95DDL: Index I0000048 Created
TIS95DDL: Index I0000050 Created
TIS95DDL: Index I0000052 Created
TIS95DDL: Index I0000054 Created
TIS95DDL: Index I0000056 Created
TIS95DDL: Index I0000058 Created
TIS95DDL: Index I0000060 Created
TIS95DDL: Index I0000062 Created
TIS95DDL: DDL Install Succeeded

IEFSIGNAL:OK
GENDB Database Installed Successfully.
*****