Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Posted Nov 9, 2006

Procedure: Ascertain Connectivity of the Relational Data Source

By William Pearson


Use this procedure to ensure connectivity with a relational data source.


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 Adventure Works DW project sample’s connection is localhost).

From within the open Analysis Services project, in the SQL Server Business Intelligence Development Studio, take the following steps:

  1. Double-click Adventure Works.ds, within the Data Sources folder seen in Solution Explorer.

The Data Source Designer opens, defaulted to the General tab, and appears with default settings as shown in Illustration 1.

Illustration: The Data Source Designer with Default Settings ...

  1. Click the Edit button on the Data Source Designer dialog.

The Connection Manager opens, and appears with default settings depicted in Illustration 2.

Illustration 2: The Connection Manager with Default Settings ...

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 the case of many of our installations, the requirement here 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 modify Server name).

  1. If appropriate, type the correct server / instance name into the Server name box of the Connection Manager. (Mine is MOTHER1\MSSQL2K5, as shown in Illustration 3.)

Illustration 3: The Connection Manager, with Corrected Settings ...

  1. Ensure that AdventureWorksDW is selected in the box labeled Select or enter a database name in the Connect to a database section of the Connection Manager dialog.
  2. Ensure that authentication settings are correct for the local environment.
  3. Click the Test Connection button.

A Connection Manager message box appears, indicating that the Test connection succeeded, assuming that our changes (or lack of same, as appropriate) are proper. The message box appears as depicted in Illustration 4.

Illustration 4: Testing Positive for Connectivity ...

  1. Click OK to dismiss the message box.
  2. Click OK to accept changes, as appropriate, and to dismiss the Connection Manager.

The Data Source Designer reappears, with our modified settings, similar to that shown in Illustration 5.

Illustration 5: The Data Source Designer with Modified Settings ...

  1. Click OK to close the Data Source Designer, and to return to the development environment.

Latest Forum Threads
DB2 Forum
Topic By Replies Updated
tables get lock during backup in db2 v9.5 Hamsoo 0 May 8th, 01:03 AM
Query to Pull Last 7 days records from a table vgoushik 0 March 20th, 06:05 PM
DB2 Visual studio addin: ANSI/Unicode problem 10Pints 0 October 5th, 02:08 AM
Things that are everbodys labor day ideas? Lipsett197 0 September 1st, 09:42 AM