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"
Article ID: 142381
Updated On:
Products
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
*****
Environment
Release : 8.6
Component : CA Gen Build Tool
Cause
The root cause is that the required version of SQL Server Shared Management Objects (SMO) is not installed e.g.
https://social.msdn.microsoft.com/Forums/ie/en-US/896e04a7-d5b0-41bf-a846-eb69dc5cc06a/microsoftsqlserverconnectioninfo-load-error?forum=adodotnetdataproviders
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.
*****
Feedback
