How to Connect ODBC Ms SQL Server Prognosis 11.9

[Marno]

Hello, 

im trying to connect ODBC prognosis but always get Error:

the SQL server is ready. whats ERROR 11023 and how to fix this, thank you. 

[SCOTT_BALDWIN]

Hello @Marno ,

The error in the screen capture indicates the ODBC driver being used is the default "ODBC SQL Server Driver" included with Windows. This driver is not TLS 1.2 compliant and is usually rendered useless by Windows Updates disabling TLS 1.0 & 1.1.

The most common solution is download the SQL Driver associated with version of SQL in use to the Prognosis Platform Managing Node, create a new ODBC connection in the System DSN tab of the ODBC wizard, and point the BigDataInsight Database Collections to the new ODBC System DSN.

Example of Windows ODBC wizard on the Managing Node:

The Online Help for Reporting Advanced starts at this URL and has many sub-links: https://help.prognosis.com/server/119/collaborate/reporting-advanced

Due to the complexity of individual environments, setting up the Reporting Advanced solution usually requires a Professional Services engagement. Please contact you Account Manager for details.

Support can help with specific Reporting Advanced issues with an isolated scope, but Support may suggest a Professional Services engagement if significant effort is needed. Please open a Support Case if additional specific help is needed beyond the suggestion in this post.

Thank you,

Scott Baldwin

[Scott_Clement]

@Hi @Marno ,

Just to add to the information Scott provided, you would need to re-create (i.e. remove and re-add) the DSN for BDIUC with the updated driver, through ODBC manager (64bit):

I'd recommend taking screen shots of the existing configuration before you remove the old DSN (so you can refer to these when re-creating).

You would also need to edit the startup documents located under the '<drive>:\Prognosis\server\configuration\BigDataInsight\UC\PrognosisScripts\deployed' directory and change the driver name specified at the end of the start up documents. The line you would need to change would be 

ODBC_DRIVER "SQL Server"

to:

ODBC_DRIVER "ODBC Driver 17 for SQL Server"

Hope this helps. If you have further questions, please let us know!

Regards,

Scott Clement