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

 

[Solved] Manage > Data Server Connections - Error on Save

Started by Cape Cod Gunny, 08 Jan 2022 04:55:52 AM

Previous topic - Next topic

Cape Cod Gunny

We just upgraded to IBM Cognos Analytics 11.0.11. I am trying to add a new Data Server Connection but I keep getting the error "Data server error occurred: cmFailReadProp" every time I try and save.

Here are the steps I am taking:

  • Manage > Data Server Connections
  • Add data server
  • Microsoft SQL Server
Settings
  • Enter the JDBC URL:
  • Autenthtentication method > Prompt for the User ID and password
  • Test > Success
  • Save
At this point I get an error message that says:
"Data server error occurred: cmFailReadProp"

What does this error mean?
What am I doing wrong?
How do I get this to work?

Solved:

This link held the key to making this work:
https://www.ibm.com/support/pages/unable-save-connection-details-datasource-using-manage-data-server-connections-functionality

I added Directory Administrators under security roles, and gave System Administrator access.
I then tried creating a Data Server Connection and it worked.  8)



Michael Riley
Marine Corps Gunnery Sergeant (Retired)

"We may never pass this way again!"