Adding a navigation connection - Microsoft SQL Server
To add a navigation connection for SQL Server:
- Open the Manage Data Sources page.
- Click and select Navigation.
- Specify a name for the data source. The name must be unique.
- Select Microsoft SQL Server as the database type.
- Specify the user name of the database owner.
- Specify the password for the database owner.
- 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.
- Select the database for the data source. If necessary, click to update the list of available databases.
- Click . If this is not successful, review and correct the connection information.
- Click .