User Tools

Site Tools


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

This website uses cookies for visitor traffic analysis. By using the website, you agree with storing the cookies on your computer.More information
aetle/connections/database/sql_server.txt · Last modified: 2015/06/10 05:04 by admin