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-boun...@lists.osgeo.org> Im Auftrag von 
Gunter Becker
Gesendet: Montag, 20. März 2023 07:56
An: MapGuide Users Mail List <mapguide-users@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-boun...@lists.osgeo.org<mailto:mapguide-users-boun...@lists.osgeo.org>>
 Im Auftrag von Gordon Luckett
Gesendet: Freitag, 17. März 2023 15:54
An: MapGuide Users Mail List 
<mapguide-users@lists.osgeo.org<mailto:mapguide-users@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.bec...@csoinfo.de<mailto:gunter.bec...@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@lists.osgeo.org<mailto:mapguide-users@lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users

Reply via email to