Cognos 8 Error: An error occurred while performing operation ‘sqlPrepareWithOptions’ status=’-121′

 

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   

Achievements vs Moments

Life is defined by moments and not by achievements. Moments make up the achievements and on our way to the achievements in life, we have moments that are either heroic or cowardly, proud or shameful, rewarding or wasteful.

So on your way to those achievements in