[mapguide-users] SQL Server connection with windows authentication

Jackie Ng jumpinjackie at gmail.com
Tue Mar 21 05:13:43 PDT 2023


If I recall correctly, windows authentication is assumed if you *do not
provide a username and password* to the FDO provider connection settings.


A good test would be to use FDO Toolbox to connect to your database without
username/password and run some raw SQL queries against it to verify it is
running under the correct security context (maybe try:
https://learn.microsoft.com/en-us/sql/t-sql/functions/current-user-transact-sql?view=sql-server-ver16
)


- Jackie

You wrote:


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?


-- 
*Please Note: I no longer create new posts or post replies to any OSGeo
mailing list through nabble. As a result, you most likely won't see this
message appear on nabble's view of any OSGeo mailing list and may only see
this message through mailing list archives or depending on your mailing
list subscription settings, through daily message digests or automated
notifications from the mailing lists.*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20230321/f68eba90/attachment.htm>


More information about the mapguide-users mailing list