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

[Nathan Deneau]

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