How to Resolve the "Unrecognized datasource" error in Pathway Studio Explore?

Description

When a user tries to access the ResNet Explore database in Pathway Studio Explore,  the following message is displayed:

Unrecognized datasource
C:\Documents and Settings\All Users\Application Data\Ariadne Genomics\ EZPathway1\Databases\resnet7explore.gpy

The error means that Pathway Studio Explore can’t connect to the SQL Server instance ARIADNE for one of the following reasons:

1. SQL Server is not started.

Resolution

Open Windows services (Start > Run, then type services.msc) and check the status of the services SQL Server (ARIADNE) and SQL Server Browser. The status of both must be “Started”, with Automatic startup type. If either of these services is not running start the service manually and correct the startup type, if necessary.

2. SQL Server installation failed or is incomplete.

If any of these services is missing from the services list at your PC then Microsoft SQL Server failed to install correctly:

 SQL Server (ARIADNE);
 SQL Server Browser;
 SQL Server Agent (ARIADNE)
 SQL Server FullText Search (ARIADNE)

To access Windows Services press Start > Run and type services.msc

Resolution

To troubleshoot the installation, check the SQL Server installation logs. If using MS SQL Server 2008, go to the directory:
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\LOG

If using MS SQL Server 2005, go to the directory:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG

Once you have identified and corrected the problem, remove ARIADNE instance of MS SQL Server and Pathway Studio Explore via Windows Control panel and repeat Pathway Studio Explore installation from the DVD.