The reason that I put it here is that that web2py pydal uses the pyodbc driver and I thought that there may be version requirements or connection parameters that would resolve this. I will now also look at the link that you sent.
On Friday, June 19, 2020 at 9:35:30 AM UTC+2, Nico Zanferrari wrote: > > Hi David, > > if I understand right you are not anymore able to connect to an external > MS SQL database from a Windows server. This does not seem a web2py issue ;-) > > Anyhow, have you checked that your web2py server and your external MS SQL > database are compatible with TLS 1.2? Have you verified it? See here > <https://social.technet.microsoft.com/Forums/en-US/a8fbb819-02c0-4b42-b593-0282605732f1/how-to-confirm-sql-connection-is-using-tls-12> > > for details. > > Nico > > > Il giorno ven 19 giu 2020 alle ore 07:45 Davidiam <david....@gmail.com > <javascript:>> ha scritto: > >> Good Morning, >> >> I would like to know what I would have to modify in order to connect to >> MS SQL from web2py with TLS 1.2. We are running web2py 2.18.5 on a Windows >> 2016 IIS server. >> >> Yesterday a security patch was installed to disable TLS 1.0 and 1.1 and >> enable TLS 1.2 and now all our MS SQL DB connections are failing. >> >> Thank you very much for your help on this, I would appreciate a rapid >> reply as our development in web2py is now blocked due to this. >> >> Kind Regards, >> David >> >> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >> - http://github.com/web2py/web2py (Source code) >> - https://code.google.com/p/web2py/issues/list (Report Issues) >> --- >> You received this message because you are subscribed to the Google Groups >> "web2py-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to web...@googlegroups.com <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/web2py/e03e78e7-24fd-494c-ab66-47f899260c82o%40googlegroups.com >> >> <https://groups.google.com/d/msgid/web2py/e03e78e7-24fd-494c-ab66-47f899260c82o%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/bd3335e9-c0e6-4fdb-9eaa-5ee210deaa37o%40googlegroups.com.