Adding a Planning connection - Microsoft SQL Server
To add a Microsoft SQL Server connection for Planning:
- Open the Manage Data Sources page.
- Click and select Planning.
- Specify a name for the data source. The name must be unique.
- Select the network protocol.
- Specify the name of the server computer on which the OLAP Server software is installed.
- Specify the Communication Manager port number for the server computer. The default is 8211 for https and 8210 for http.
- Specify the administrator user name.
- Specify the password for the administrator user.
- Select the BI OLAP database for the data source. If necessary, click Refresh to update the list of available databases.
- Select Microsoft SQL Server as the database server 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 Planning relational database to connect to 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 .