[mapguide-users] SQL Server connection with windows authentication

[Gunter Becker]

Okay, unfortunately this doesn't work for me.

The MapGuide server now runs under a Windows account that has access to the SQL server. I checked the user's connection to the database with another program and it works.
But unfortunately I still can't connect MapGuide to the database.

What fields do I need to enter in maestro's FeatureSource Editor? How do I tell the provider to use windows authentication and not SQL Server authentication?


Von: mapguide-users <mapguide-users-bounces at lists.osgeo.org> Im Auftrag von Gordon Luckett
Gesendet: Freitag, 17. März 2023 15:54
An: MapGuide Users Mail List <mapguide-users at lists.osgeo.org>
Betreff: Re: [mapguide-users] SQL Server connection with windows authentication

If mapguide server is logged into SQL Server as a user that have windows authentication, you should be able to do this.

For example, make a network user called mapguide_server_user, and log into MapGuide Services as that user and grant that user access to SQL Server, you can use Windows Authentication.

On Fri, Mar 17, 2023 at 10:46 AM Gunter Becker <gunter.becker at csoinfo.de<mailto:gunter.becker at csoinfo.de>> wrote:
Hi,


is it possible to connect to a SQL Server database using integrated security (windows authentication) in FDO Provider? If so, how can I do that in Maestro, for example? So far I've only done this with SQL authentication.

Thanks, Gunter
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org<mailto:mapguide-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/mapguide-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20230320/e90c6362/attachment.htm>