How to specify a data source
New Information - SQL Server 2000 SP3.
To specify a data source
- In the Analysis Manager tree pane, expand the database that will draw data from the data source.
- Right-click the Data Sources folder, and then click New Data Source.
- In the Data Link Properties dialog box, on the Provider tab, click an OLE DB provider.
- Complete the Connection tab, which varies by provider.
Note If you are connecting to a SQL Server™ 2000 data provider, it is recommended that, under Enter information to log on to the server, you select Use Windows NT Integrated security.
Security Note If you select Allow saving password, the password is saved unmasked and unencrypted with the connection string. This can create a security vulnerability if the repository is accessible to other users.
If, in Step 3 you selected Microsoft® OLE DB Provider for ODBC Drivers, on the Connection tab click Use data source name, click the drop-down arrow to display a list of data source names, and then click a data source name. If the data source name you want to select is not in the list, you must define one. In Control Panel, use the ODBC Data Source Administrator to define the data source name, and then return to the Connection tab and click Refresh. For more information, see Before Administering Analysis Services.
- To determine whether the data source is correctly connected, click Test Connection. If the connection is correct, you receive a message indicating that the test connection succeeded. Click OK to clear the message.
- In the Data Link Properties dialog box, click OK.