Procedure: Ascertain Connectivity of the Analysis Services Data Source
October 11, 2006
Use this procedure to ensure connectivity of a projects Shared Data Source with an Analysis Services database.
Many of us will be running side-by-side installations of MSSQL Server 2000 and MSSQL Server 2005. This means that our installation of the latter will need to be referenced, within a data source context, as a server / instance combination, versus a server name alone (the default for the AdventureWorks Sample Reports project samples connection is localhost).
From within the open Adventure Works Reports Sample project, in the SQL Server Business Intelligence Development Studio, take the following steps:
The Shared Data Source dialog opens, and appears with default settings as depicted in Illustration 1.
The Connection Properties dialog opens, and appears with default settings shown in Illustration 2.
We note that the default Server name is localhost. While this might prove an adequate setting for a PC with only MSSQL Server 2005 installed (default instance), in many of our environments, the requirement is for the server / instance combination that correctly identifies the correct MSSQL Server 2005 instance. (Clicking the Test Connection button at this point will provide confirmation as to whether we need to make this change).
A message box appears, indicating that the Test connection succeeded, assuming that our changes (or lack of same, as appropriate) are appropriate. The message box appears as shown in Illustration 4.
The Shared Data Source dialog appears, with our modified settings, similar to that depicted in Illustration 5.