Re: [web2py] We use web2p 2.18.5 with MS SQL on Windows IIS 10. Recently a security patch on the server enforced stricter SSL rules and we can no longer use TLS 1.0 and 1.1. so it has to be TLS 1.2

[Davidiam]

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 
> 
>  
> for details. 
>
> Nico
>
>
> Il giorno ven 19 giu 2020 alle ore 07:45 Davidiam  > 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 .
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/web2py/e03e78e7-24fd-494c-ab66-47f899260c82o%40googlegroups.com
>>  
>> 
>> .
>>
>

-- 
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.

Re: [web2py] We use web2p 2.18.5 with MS SQL on Windows IIS 10. Recently a security patch on the server enforced stricter SSL rules and we can no longer use TLS 1.0 and 1.1. so it has to be TLS 1.2

[Nico Zanferrari]

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

for details.

Nico


Il giorno ven 19 giu 2020 alle ore 07:45 Davidiam 
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 web2py+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/e03e78e7-24fd-494c-ab66-47f899260c82o%40googlegroups.com
> 
> .
>

-- 
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/CAAE8D_C-%2B-rH3YB4WtxBMK7PnGc7Fp1yM146m1-y_S-fSEKZ5Q%40mail.gmail.com.

[web2py] We use web2p 2.18.5 with MS SQL on Windows IIS 10. Recently a security patch on the server enforced stricter SSL rules and we can no longer use TLS 1.0 and 1.1. so it has to be TLS 1.2

[Davidiam]

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 web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/e03e78e7-24fd-494c-ab66-47f899260c82o%40googlegroups.com.