[mapguide-users] WG: SQL Server connection with windows authentication

[Gunter Becker]

OK, I got it.

First, I wanted to change an existing feature source, which didn't work.
I hHad to create a new FeatureSource from scratch and just put in the service name.

Thank you Gordon


Von: mapguide-users <mapguide-users-bounces at lists.osgeo.org> Im Auftrag von Gunter Becker
Gesendet: Montag, 20. März 2023 07:56
An: MapGuide Users Mail List <mapguide-users at lists.osgeo.org>
Betreff: Re: [mapguide-users] SQL Server connection with windows authentication

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<mailto: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<mailto: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/56ed9d8b/attachment.htm>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: ATT00001.txt
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20230320/56ed9d8b/attachment.txt>