[mapguide-users] Fwd: [OSGeo-Discuss] Why does OSGeo FDO Provider for SQL Server Spatial try to access the wrong database?

[Johan Van de Wauw]

Nathan,

You are more likely to get good answers on the mapguide
mailinglist(I'm forwarding your mail).

Johan.

---------- Forwarded message ----------
From: Nathan Deneau <NATHAN.DENEAU at asu.edu>
Date: Wed, Sep 18, 2013 at 10:00 PM
Subject: RE: [OSGeo-Discuss] Why does OSGeo FDO Provider for SQL
Server Spatial try to access the wrong database?
To: Johan Van de Wauw <johan.vandewauw at gmail.com>
Cc: "Discuss at lists.osgeo.org" <Discuss at lists.osgeo.org>


Yes, AutoCAD Map 3D, sorry. The login that accesses the spatial
database from AutoCad Map 3D using the same FDO provider has server
admin privileges so he would not receive the same error. This is a SQL
Server host with many databases so the administrators will not want to
grant me access beyond read access. How do I accomplish this given the
following facts?

All user logins belong to the public role and cannot be removed from
the public role in MS SQL Server. The public role has "VIEW ANY
DATABASE" permission by default in MS SQL Server. So that means we can
always expect the default behavior of a login to be able to see all
databases even if that user cannot read (select) from all of those
databases. I was hoping that the FDO provider would ignore any
databases that it can see but not read from and simply move on to the
next database in the list eventually finding any databases that the
login does have permission to read and accumulating them - or at least
either honor the default database of the user login or else allow an
option to ignore all but a specified database.

The error in my FDO connection test seems to show that it is trying to
connect to these other databases and crashes when my login does not
have permissions and throws the error I included in my previous post.
So I have to assume that there is a more narrow set of allowable
configurations of SQL Server, the FDO provider, or Autodesk Studio
(e.g. not allowed to have other databases my login can't read on the
host, must change public role which potentially affects everyone else
on the shared host, must share a user account with owner privileges,
must specify a database for the OSGeo FDO provider for SQL Serve
Spatial somewhere, must set Autodesk Studio setting somewhere to
specify the one spatial database).

Thank You,

Nathan


-----Original Message-----
From: Johan
Sent: Tuesday, September 17, 2013 11:40 PM
To: Nathan
Subject: Re: [OSGeo-Discuss] Why does OSGeo FDO Provider for SQL
Server Spatial try to access the wrong database?

On Tue, Sep 17, 2013 at 5:52 PM, Nathan wrote:

>
> - The author of the SQL Server Spatial database is able to access the
> geometry from other products (AutoCad I believe).

If it really is AutoCAD he probably means AutoCAD Map or Civil 3D. In
that case he can export a map to mapguide or autodesk infrastructure
map server by choosing file\publish\publish to map server.

This will copy the exact settings that were used in autocad.

But I think the error is rather due to MS SQL security settings. Are
you using the same username/password in both cases?

>
> - I can see other database names from Microsoft SQL Management Studio
> but I do not have permissions to view any details about these databases.
>
> - The first database listed in the databases names I can see is the
> "WrongDatabaseNotMyDefault" database from the error - the default
> database for my login is the thirteenth (13th) database down the list!
>
>
>
> Thanks For Your Help,
>
> Nathan
>
>
> _______________________________________________
> Discuss mailing list
> Discuss at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/discuss