[gdal-dev] Can not connect to MSSQL database on Azure

[Paul Meems]

Thanks Tamas,

You are completely right. We misinterpret de code.
Thanks to the link you provided we now understand we need to use a
different connection string:
MSSQL:server=***;database=***;trusted_connection=no;uid=***;pwd=***


Thanks,

Paul

*Paul Meems *
Release manager, configuration manager
and forum moderator of MapWindow GIS.
www.mapwindow.org

Owner of MapWindow.nl - Support for
Dutch speaking users.
www.mapwindow.nl


Download the latest MapWinGIS mapping engine.
<https://mapwingis.codeplex.com/releases>

Download the latest MapWindow 5 open source desktop application.
<https://mapwindow5.codeplex.com/releases>

2015-12-28 22:18 GMT+01:00 Tamas Szekeres <szekerest at gmail.com>:

> Hi Paul,
>
> I don't think we are hard coding trusted_connection in the MSSQL
> connection strings. The UID and PWD is also accepted in the ODBC connection
> strings according to:
> https://msdn.microsoft.com/en-us/library/ms130822.aspx
>
> Best regards,
>
> Tamas
>
>
> 2015-12-28 22:05 GMT+01:00 Paul Meems <bontepaarden at gmail.com>:
>
>> I'm trying to connect to a MSSQL database on Azure using a SQL Server
>> user account but I get this from GDAL (v2): Unable to initialize
>> connection to the server for MSSQL:server=***;database=***;user=***
>> ;password=*** [SQL Server]Login failed. The login is from an untrusted
>> domain and cannot be used with Windows authentication.
>>
>> A co-worker looked at the code of the MSSQL driver and noticed you
>> are using the ODBC drivers, but are hard coding the trusted_connection
>> parameter to be yes.
>> Is this by design?
>> Should I file a issue report?
>>
>> Thanks,
>>
>> Paul
>>
>> *Paul Meems *
>> Release manager, configuration manager
>> and forum moderator of MapWindow GIS.
>> www.mapwindow.org
>>
>> Owner of MapWindow.nl - Support for
>> Dutch speaking users.
>> www.mapwindow.nl
>>
>>
>> Download the latest MapWinGIS mapping engine.
>> <https://mapwingis.codeplex.com/releases>
>>
>> Download the latest MapWindow 5 open source desktop application.
>> <https://mapwindow5.codeplex.com/releases>
>>
>> _______________________________________________
>> gdal-dev mailing list
>> gdal-dev at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20151229/b66920d9/attachment-0001.html>