Skip to content

Configure SQL

SQL Server Connection Type

Select the mode of connection to the SQL Server instance

User Access Level required to use these Connection properties

Specify the Access Level required to use these SQL Connection properties

SQL Server Timeout (0 = no timeout)

Specify the time before SQL Server tasks are timed out (in seconds)

Property

Other connection properties necessary will vary and will depend on the local set up of SQL Server such as the authentication used.  Additional rows can be added, by right-clicking on a Row Heading and selecting from the pop-up menu, allowing any additional property names and their values to be specified.

For example, if using SQL Server Authentication add the following 2 rows below the Server row:

  • User ID
  • Password

Enter the details of your User ID and password for the SQL Authentication details.

Value

Other connection properties necessary will vary and will depend on the local setup of SQL Server such as the authentication used.  Additional rows can be added, by right-clicking on a Row Heading and selecting from the pop-up menu, allowing any additional property names and their values to be specified.

For example, if using SQL Server Authentication add the following 2 rows below the Server row:

  • User ID
  • Password

Enter the details of your User ID and password for the SQL Authentication details.

Grid Help

Right-clicking on a column heading presents a menu with the following options which allow you to expand or reduce the number of columns of data to be entered:

  • Add a new column to the right of the grid;
  • Insert a new column at the position of the cursor; and
  • Delete the current column at the position of the cursor.

Grid Help

Right-clicking on the Top Left Corner of the grid displays a menu which allows you to set the following Grid Editing Options:

  • Editing of a cell can be invoked by either clicking on the cell or by pressing F2 when the cell is active (Clicking will only change the current active cell); and
  • determine the cursor movement once editing is complete to be either to the next cell down, the next cell to the right or to stay in the current cell.

Apply to Users

Apply currentSQL Connection properties to Users

Test Connection

Test SQL Connection properties

SaveAs

Click the Save As button to save with a new file name.

Save

Clicking on the Save button allows you to save the entries.

Quit

Clicking on the Quit button allows you to exit without saving any of your changes.

In some of the screens you will be asked to confirm if you want to exit Ignoring all changes. If you click Yes, the file will be closed without saving any changes. If you click No you will be returned to your original screen.

From the Browser, the Quit button will take you to a graphical display of the results.