Databases Reference
In-Depth Information
If you need to change the data provider, you will use the Change Data Source dialog, shown in Figure 5-38.
Select the Data source for Microsoft SQL Server Analysis Services and verify the Data provider selection
is the .NET Framework Data Provider for Microsoft Analysis Services. Click the OK button to return to
the previous dialog.
Figure 5-38
My Analysis Server is my local machine, so I have entered localhost for the Server name (see Figure 5-39).
You will need to enter your server name here if the Analysis Server isn't local. Select the Analysis
Services database using the lower drop-down list, and then click the OK button.
Figure 5-39
As you see in Figure 5-40, this generates a connection string. If you have this information, you can skip
the previous steps and type this text directly into the Connection string text box. In either case, after the
provider type and connection string have been entered, select the Credentials tab.
Search WWH ::




Custom Search