Adding a Microsoft SQL Server connection

To add a Microsoft SQL Server connection:

  1. Open the Manage Data Sources page.
  2. Click New and select Microsoft SQL Server.
  3. Specify a name for the data source. The name must be unique.
  4. Specify the user name of the database owner.
  5. Specify the password for the database owner.
  6. 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.
  7. Select the database for the data source. If necessary, click Refresh to update the list of available databases.
  8. Click Test Connection. If this is not successful, review and correct the connection information.
  9. Click Save.