Microsoft SQL Server Connection

The procedure for many database connections is very similar. In the case of MS SQL Server, it is necessary to specify the server, database name and user name/password combination.

An SQL Server connection setup requires the following steps:

  • In the Name Text Box type in a new name for the connection you are about to create
  • Select a Server Name from Server Drop Down List
  • Select a Database Name from the Drop Down List
  • Fill in Username/Password for the database you wish to connect to
If you are unsure of these parameters, please contact your Database Administrator for the correct settings.
  • Click Test to ensure the details you have provided are correct
  • Click OK to close the connection properties window
Leave user name and password blank to use Windows Authentication
To connect using different port use "server name,port" format

ODBC Drivers

Our software automatically selects the highest installed driver in the following order

  • ODBC Driver 17 for SQL Server
  • ODBC Driver 13 for SQL Server
  • ODBC Driver 11 for SQL Server
  • SQL Server Native Client 11.0
  • SQL Server Native Client 10.0
  • SQL Native Client
  • SQL Server

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

  • vimpe/connections/database/sql_server.txt
  • Last modified: 01/08/2022 14:20
  • by admin