[mapguide-users] Support Sqlserver 2016 inPASS mode

[Bruno Scott]

Hi all,
I'm trying to connect to a Sqlserver 2016 in PASS ( platform as service) and
Mapguide (more likely fdo) as some problem getting access to the master
schema.
As someone already tried this ?
Bruno Scott



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html

[Jackie Ng]

Who is the paas provider? Azure? Amazon (RDS)? Other?

- Jackie



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html

[Bruno Scott]

Actually it's azure.
Does it matter?

Thanks



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html

[Jackie Ng]

There's an un-applied patch for the SQL Server provider to enable support for
Azure-managed SQL Server databases: http://trac.osgeo.org/fdo/ticket/869

I don't know if this is still applicable for what is currently offered by
Azure or AWS

- Jackie



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html

[Hans Milling]

MapGuide or FDO used to have a bug, where it tried to read information about
all databases on the server, even the databases that the user have no access
to. This resulted in an error. Solution was to use a user on the database
server that had access to everything (the sa user) to create the feature
source, and then change the username/password to the correct user, after the
datasource were created.
I am not sure if you experience the same?

Best regards
Hans Milling...



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html