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

Video Tutorial

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: 17/09/2018 10:33
  • by admin