Every now and then when I or a user runs a Cognos report we get the following error:
An error occurred while performing operation ‘sqlPrepareWithOptions’ status=’-121′.
Description:
UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Deferred prepare could not be completed. UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Connection failure (SQLSTATE=08S01, SQLERRORCODE=0) RQP-DEF-0149
