Hello, if you're using SQL Server stored procedures (SPROCS) in your Cognos 8 Framework Manager model as the source for your model's query subjects, then you should make sure that you have a valid user signon defined in Cognos Connection that has the proper permissions to execute the SPROC.
If not, then you may a recieve an error similar to the following:
RQP-DEF-0177 An error occurred while performing operation 'sqlExecute'