Showing results for 
Search instead for 
Did you mean: 

How to Connect ODBC Ms SQL Server Prognosis 11.9

IR Partner

How to Connect ODBC Ms SQL Server Prognosis 11.9


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. 

Tags (2)

Re: How to Connect ODBC Ms SQL Server Prognosis 11.9

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:

ODBC wizard screen capture.jpg


The Online Help for Reporting Advanced starts at this URL and has many sub-links:


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



Re: How to Connect ODBC Ms SQL Server Prognosis 11.9

@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):


ODBC Manager - DSN.jpg

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 "ODBC Driver 17 for SQL Server"

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


Scott Clement