Add MSSQL Tenant

<< Click to Display Table of Contents >>

SmartConnect 2017

Add MSSQL Tenant

If updates of more than one MSSQL server are required, a tenant may be added to point to the new server / database.


To define a new MSSQL tenant (database):

1.Select create, or select the Maps Quick Link and double click on the map to be edited.
2.If creating a new map enter the map id, description, data source, key field and MSSQL destination information.
3.Select the Databases button to open the databases window.
4.Select the Add button to open the MSSQL tenants window.
5.Enter the name of the SQL server.
6.Enter the required authentication type.
7.Enter the MSSQL login and password for the new server.
8.Select Connect to connect to the server and retrieve a list of databases.
9.Select the required target database.
10.Select OK to close the server connection window.

MS SQL Tenants