I don't have a Windows server machine but on an up-to-date windows 7 box
the latest Microsoft driver works against SQLServer 2012.
Ian
PS Andrea I've cleaned up the pull request
https://github.com/geotools/geotools/pull/586 that makes that change
On Wed Nov 12 2014 at 11:24:57 AM Ian Turton <[email protected]> wrote:
> I updated trunk (GeoTools) to use the latest ms driver in a recent PR but
> it looks like the JIRA got lost so I'll poke it later.
>
> I'll apply the security patch now and see if I can recreate the issue
> locally.
>
> Ian
>
> On 11:17, Wed, 12 Nov 2014 Andrea Aime <[email protected]>
> wrote:
>
>> On Wed, Nov 12, 2014 at 11:46 AM, Lukas Bergliden <
>> [email protected]> wrote:
>>
>>> One of our production geoservers (2.5) went out of buissnes tonight
>>> after its database server installed the security update
>>> https://technet.microsoft.com/library/security/MS14-066.
>>> The updated server run a sql server 2012 Geoserver connects to this
>>> database from a linux machine trough the sql server and the app schema
>>> plugins.
>>> We thought about setting the sql server in force encryption = false but
>>> it seems that the plugin always uses encryption if available.
>>>
>>
>> I don't think the data store has any support for encryption actually...
>> the only thing remotely related is the "integrated secuty" flag, if
>> you have it in the store configuration try enabling/disabling it.
>> Also I'd suggest to download a more recent JDBC driver from Microsoft,
>> that might help too
>>
>> Cheers
>> Andrea
>>
>>
>> --
>> ==
>> GeoServer Professional Services from the experts! Visit
>> http://goo.gl/NWWaa2 for more information.
>> ==
>>
>> Ing. Andrea Aime
>> @geowolf
>> Technical Lead
>>
>> GeoSolutions S.A.S.
>> Via Poggio alle Viti 1187
>> 55054 Massarosa (LU)
>> Italy
>> phone: +39 0584 962313
>> fax: +39 0584 1660272
>> mob: +39 339 8844549
>>
>> http://www.geo-solutions.it
>> http://twitter.com/geosolutions_it
>>
>> *AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*
>>
>> Le informazioni contenute in questo messaggio di posta elettronica e/o
>> nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
>> loro utilizzo è consentito esclusivamente al destinatario del messaggio,
>> per le finalità indicate nel messaggio stesso. Qualora riceviate questo
>> messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
>> darcene notizia via e-mail e di procedere alla distruzione del messaggio
>> stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
>> divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
>> utilizzarlo per finalità diverse, costituisce comportamento contrario ai
>> principi dettati dal D.Lgs. 196/2003.
>>
>>
>>
>> The information in this message and/or attachments, is intended solely
>> for the attention and use of the named addressee(s) and may be confidential
>> or proprietary in nature or covered by the provisions of privacy act
>> (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
>> Code).Any use not in accord with its purpose, any disclosure, reproduction,
>> copying, distribution, or either dissemination, either whole or partial, is
>> strictly forbidden except previous formal approval of the named
>> addressee(s). If you are not the intended recipient, please contact
>> immediately the sender by telephone, fax or e-mail and delete the
>> information in this message that has been received in error. The sender
>> does not give any warranty or accept liability as the content, accuracy or
>> completeness of sent messages and accepts no responsibility for changes
>> made after they were sent or for other risks which arise as a result of
>> e-mail transmission, viruses, etc.
>>
>> -------------------------------------------------------
>> ------------------------------------------------------------
>> ------------------
>> Comprehensive Server Monitoring with Site24x7.
>> Monitor 10 servers for $9/Month.
>> Get alerted through email, SMS, voice calls or mobile push notifications.
>> Take corrective actions from your mobile device.
>> http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/
>> 4140/ostg.clktrk_______________________________________________
>> Geoserver-users mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>
------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
