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 (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)