Hi all, could do with some opinions on this.
We are running C8 against a SQL 2000 database.
Recently we have begun to receive error messages intermittently with the following error code whenever we attempt to run or validate reports.
UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Connection failure (SQLSTATE=08S01, SQLERRORCODE=0)
I have serveral other SQL database that exist within the Same SQL instance and I have no issues with these and can quite happily run reports against them.
I can test a connection to all our of my sql databases with success so I'm now stuck as to where to go.
Cognos KB doc 1031255.1 claims that its a network issue, but my infrastructure department claim its Cognos causing the issue.