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.

Connection

Creating New Connection

• 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 Authentication Method
• Select a Database Name from the Drop Down List
• Fill in Username/Password for the database you wish to connect to
• Click Test to ensure the details you have provided are correct
• Click OK to close the connection properties window

To connect using different port use “server name,port” format

Comments

User fields

ODBC Drivers

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

• ODBC Driver 18 for SQL Server
• 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

Video Tutorial

Used by

1. Microsoft SQL Server Reader
2. Microsoft SQL Server Writer
3. Database Loop Action
4. Sql Script Action
5. Sql Data Check Action
6. Check Connection Action
7. SQL To Text Dynamic Action
8. SQL To XML Dynamic Action
9. SQL To Insert Dynamic Action
10. SQL To Excel Dynamic Action
11. SQL To QVD Dynamic Action
12. SQL To QVX Dynamic Action
13. Select Value Action
14. SQL Record to Variables Action
15. SQL to Variables Action

Useful Links

• Getting latest version of SQL Server ODBC Drivers
• List of OleDB drivers download links