How to add or change a SQL connection

If the current Microsoft® SQL Server™ 2000 Analysis Services database or current SQL database does not answer all of the questions that a user might ask, modify the project by adding a new or changing the current SQL database connection. There can be, at most, one SQL and one Analysis Services database per project.

Note  Before adding a SQL connection to an Analysis Services project, make sure that you are a member of the OLAP Administrators group and the Microsoft Windows NT® 4.0 or Windows® 2000 user group on the server of the Analysis Services database for which the model is being built. You must have OLAP Administrator permissions to load the tables underlying the cubes using Decision Support Objects (DSO).

To add or change a SQL connection

1. Select the project to which the database is being added.
   
   
2. On the Project menu, click <Project name> Properties.
   
   
3. On the Data Connection tab, select Enable SQL if adding a SQL database.

   Note  Both SQL and Analysis Services databases can be enabled.

4. On the Provider tab of the Data Link Properties dialog box, select the OLE DB provider and then click Next.
   
   
5. On the Connection tab, enter or select the server or data source name, the log on information, and the database, and then click OK.

See Also

Expanding an English Query Model

Data Connection Tab (Project Properties Dialog Box)

Enabling SQL for an English Query Model

Project Properties Dialog Box