Specifying Data Sources
New Information - SQL Server 2000 SP3.
For each of your databases, specify one or more data sources that will provide data for your cubes, data mining models, and other objects. When you specify a data source, Analysis Manager retrieves a list of available OLE DB providers. If you want to use a database accessible through an ODBC driver as a data source, select Microsoft® OLE DB Provider for ODBC Drivers as the OLE DB provider, and then select the ODBC data source name (DSN) for the database as defined in ODBC Data Source Administrator from a separate dropdown list. You can easily select a provider and, if necessary, a DSN from these lists.
Note DSNs defined in ODBC Data Source Administrator must be defined as system DSNs.
If you later edit the data source and change the provider, errors can occur during subsequent processing of objects. For example, in a time dimension, the values for the levels' Member Key Column and Member Name Column properties are frequently SQL expressions. If the syntax of the expressions is supported by the original provider, but not by the new provider, processing the dimension will fail.
To specify a data source, use the Data Link Properties dialog box.
To specify a data source
If you specify a SQL Server data source that uses Windows Authentication, the MSSQLServerOLAPService service must have permissions to access the data source. Otherwise, Analysis Services administrators cannot process the objects they maintain using Analysis Manager.