COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Query Studio => Topic started by: jayadev on 19 May 2011 04:02:10 AM

Title: Error: 'sqlOpenResult' status '-28'
Post by: jayadev on 19 May 2011 04:02:10 AM
Hi,

I am attempting to run a Cognos 8 report and I am the getting the following error: 'sqlOpenResult' status '-28'

It suggests that there might have been changes to the SP, but there have not been. There have been no changes to the report or the query as well.

Where could the error lie? I tested the same report in Dev Region and there it runs fine but not in the QA Region.

Could someone help me out? If there are some details required, please let me know.

Thanks,
Jayadev Swain
Title: Re: Error: 'sqlOpenResult' status '-28'
Post by: navissar on 02 Jun 2011 01:29:16 PM
It's kind of a general error. Try testing the data source(s) to see if you can establish a connection to them at all. If not, it could be that the credentials you're using have expired or that your QA server is no longer allowed access to the data source(s).