After installing a MS SQL Server Patch, connection to the CMS stopped due to a critical error.
We had to upgrade the ODBC driver to Driver 11 for SQL Server. This allowed us to reconnect to CMS. Reports seem to be running on schedule, but they fail to get sent out.
We receive this error when the report fails:
Database error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(SECDoClientHandshake())..(IES 10901)
Help others by sharing your knowledge.
AnswerRequest clarification before answering.
This issue has been resolved.
We upgraded the ODBC Drivers to use the SQL Native ODBC drivers.
Reports are now running as expected.
Thanks to all who tried to help out.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
4.1 supports SQL 2014 from SP4 only and you have to use SQL native driver 11
The error comes from SQL Server itself, so you can't fix it on BOE side.
See https://social.msdn.microsoft.com/Forums/en-US/8a6a3688-7d49-429d-a68c-05f46c4b33b5/unable-to-connec...
https://www.sqlnethub.com/blog/dbnetlib-connectionopen-secdoclienthandshake-ssl-security-error-resol...
As none of the versions you mentioned are supported by their vendors anymore - your best solution is to upgrade to supported versions of BOE and SQL Server.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.