Setting Up the Connection Properties
How to set up the connection to the server.
In the Connection Properties dialog box, go to the Data source and select Change.
In the Change Data Source dialog box, select the data source to be used.
Select OK, which will take you back to the Connection Properties dialog box.
Enter the Server name (IP address), or select from the dropdown list.
In Log on to the server select either Windows Authentication or SQL Server Authentication to log on to the server.
For SQL Server Authentication enter the User name and Password. Select Save my password for easy access in future.
In To connect to a database select either Select or enter a database name or Attach a database file.
For Attach a database file browse for the file and enter the Logical name.
Select Advanced to choose further entries from the Advanced Properties dialog box, and select OK to apply.
Select Test Connection to check if the connection works or select Connect to ToolsNet to connect.
