Setting up Cognos Metrics Studio Samples

[chrismgarvey]

I am receiving the following error message within the \\c8install\logs\MetricMaintenance\ folder when attempting to run the "Import and transfer data from files into metrics store".

SQLState = 08001, NativeError = 53
Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [53].
SQLState = HYT00, NativeError = 0
Error = [Microsoft][SQL Native Client]Login timeout expired
SQLState = 08001, NativeError = 53
Error = [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.


I have assigned db_owner privilages to the SQL Server account that accesses the database.

Any assistance would be greatly appreciated.

[MFGF]

Are you by any chance using SQL Server 2005 Express Edition?  If so, you will not get it to work - it needs to be the Standard or Enterprise edition to be used as a metric store database.

Regards,

MF.

[chrismgarvey]

Hi MF,

Yes! I am using the Express Version of SQL 2005. Is this limitation documented anywhere?

[MFGF]

Yes - if you look at the 'Cognos 8 Supported Environments' page on the IBM support site here, it states that SQL Server 2005 (except Express Edition) is supported as a metric store.

SQL Server 2005 Express Edition can be used as a normal data source, but can't handle the JDBC connection required to use it as a metric store.

Best bet is to upgrade to Standard Edition - it should work perfectly then!

Best regards,

MF.