I was wondering if you could tell me if this is a bug or else how to configuring this correctly? I receive the following error when trying to test my connection using the built-in OSGeo FDO Provider for SQL Server Spatial from Autodesk Studio 2014 to a MS SQL Server Spatial server (v 10.50.4000)...
An exception occurred in FDO component.
RDBMS: [Microsoft][SQL Server Native Client 10.0][SQL Server]The server principal "myLoginHere" is not able to access the database "WrongDatabaseNotMyDefault" under the current security context. (Cause: , Root Cause: RDBMS: [Microsoft][SQL Server Native Client 10.0][SQL Server]The server principal "myLoginHere" is not able to access the database "WrongDatabaseNotMyDefault" under the current security context. )
Additional details:
- The database listed in the error above is not what I expected. I was expecting the FDO to try and connect to the default database configured to my login id.
-I am able to connect and see data but am not able to select geometry from AIMS Studio using the OSGeo FDO Provider for ODBC.
-I am able to connect and see data and geometry rows using Microsoft SQL Management Studio.
-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 I can see is the "WrongDatabaseNotMyDefault" database from the error!
Thanks For Your Help,
Nathan