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.
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.
Hi MF,
Yes! I am using the Express Version of SQL 2005. Is this limitation documented anywhere?
Yes - if you look at the 'Cognos 8 Supported Environments' page on the IBM support site here (http://www-01.ibm.com/support/docview.wss?uid=swg27017522#metricstore), 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.