"Microsoft SQL Server" database type does not appear in the list to create a database

Document ID : KB000007696
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

"Microsoft SQL Server" database type does not appear in the list to create a mdb database

Environment:
Service Desk Manager 14.1 and laterMicrosoft SQL Server 2012
Cause:

SQL 2012 client is not installed in Service Desk Manager server, Installing SQL client in SDM server is a prerequisite, this will allow SDM to connect to the remote SQL database and then should show the "Microsoft SQL Server" database type in the list.

Further information about hardware and software prerequisites for SDM installation can be found in the link bellow:

Database management systems requirements

Resolution:

1) Close sdci_MDB.exe and installation wizard

2) Install SQL client,  including the connectivity, and SQL Tools like Management Studio in SDM Server using SQL Server installer/ISO. See an example in the following link:

How to install SQL Server Client Tools?

3) Run the installation wizard and sdci_MDB.exe to create the database. This time "Microsoft SQL Server" database type will appear in the list.