I have an installation of Cognos Controller 8.2. The installation of application seems to be all 100%.I can create blank SQL database use the application to upgrade the tables but as soon as I populate the database with data and try to optimise from the application there is an issue. It gives me the error below:
Standard error Number 5
Source: Frango dircect.Optimise.DeleteTempFox#controllerProxyClie nt
server was unable to process request-->System.Security.Security Exception: Permission Denied
I have checked permissions on the database and all is fine "fastnet" is added as the DB owner and the SQL instance is 100%, Can anyone please shed some light on this.
Hi PMASchmed I am sure that it is not a problem with SQL I am quite convinced that this is an issue within the Cognos Controller application but the problem is I have no clue as to where to start looking within the Controller application.