If you are unable to create a new account, please email support@bspsoftware.com

 

Urgent requirement :--OLEDB error in Creating Cognos planning Contributor

Started by cogplan, 28 Dec 2010 10:08:32 AM

Previous topic - Next topic

cogplan

Hi techies

             I have a peculiar situation where i am unable to create contributor applications. hence can you let me know the solution for my query at the earliest as its a very urgent requirement

             I tried creating a new application using old database/datastore. but at the end of application creation. I am facing an error

" Unable to execute the statement. Cannot use file (data base mdf file) for clustered server. only formatted files on which the cluster resource of the server has a dependency can be used.

Error number 2147217900 was raised by Microsoft OLEDB provider for SQL. native RDBMS error 1802



Please do reply me at the earliest as its an urgent requirement and I have to finish off this at the earliest.. :( >:( :(



Regards

cogplan

ericlfg

Hey Cogplan,

It might be that there's a specific configuration syntax you must use for the datastore location you've specified in the application creation wizard...   You may want to head into SQL management studio and take a look at the configuration of current applications.  See where the datastore files are being stored and ensure you're using the same path when you go through the application creation wizard.

I would suspect that you're trying to use a path during the creation wizard that hasn't been configured as a dependency in SQL server. 

Hope this helps...

cogplan

thanks for the information. I checked  in sql and now  added myself as an administrator . hence its working fine. now.. thanks  aton