Adding a navigation connection - Microsoft SQL Server

To add a navigation connection for SQL Server:

  1. Open the Manage Data Sources page.
  2. Click New and select Navigation.
  3. Specify a name for the data source. The name must be unique.
  4. Select Microsoft SQL Server as the database type.
  5. Specify the user name of the database owner.
  6. Specify the password for the database owner.
  7. Specify the name of the server computer on which the SQL Server software is installed. If a SQL instance is used, it must be appended to the name. For example, MyServerName\SQL2008.
  8. Select the database for the data source. If necessary, click Refresh to update the list of available databases.
  9. Click Test Connection. If this is not successful, review and correct the connection information.
  10. Click Save.