Using Maestro ver 6.0.0.63 I am unable to connect to a MS SQL Server database on a remote server. I am able to connect to a copy of the database on the localhost. The error in Maestro is "The remote server returned an error: (559) MgFdoException". I am able to connect to the remote database using SqlSpatialTools build 3759 and query the table with spatial data. The remote version is running on the default instance of sql server. Using the same credentials for all connections. Also tried with sa credentials and it still didn't work. Log entry (shown below) says Native Client 10.0 required. Native Client 10.0 is installed on both the local and remote sql servers.
Remote Server Windows Server 2008 R2 MS SQL Server Standard Edition (64-bit) v 10.50.6000 SP3 (2008 R2) Mapguide OS 3.1 (64bit) Locahost Windows 10 MS SQL Server Express Edition with Advanced Services (64-bit) v 10.50.4042 SP2 Mapguide OS 3.1 (64bit) The Mapguide server logs the following error: <2017-02-16T12:35:29> 2400 MapGuide Maestro v6.0.0.63 10.0.0.128 greg Error: An exception occurred in FDO component. Error occurred in Feature Source (Session:54099516-f47e-11e6-8000-90b11c34bb0b_en_MTI3LjAuMC4x0AFC0AFB0AFA//0479af0e-fb2f-437f-a5b3-5d603d362f26.FeatureSource): An exception occurred in FDO component. Please install 'SQL Server Native Client 10.0' or upper to be able to use the provider - MgFdoConnectionManager.Open() line 333 file c:\working\build_area\mapguide\3.1.0\x64\mgdev\server\src\common\manager\FdoConnectionManager.cpp - MgFdoConnectionManager.CacheFdoConnection() line 1097 file c:\working\build_area\mapguide\3.1.0\x64\mgdev\server\src\common\manager\FdoConnectionManager.cpp - MgFdoConnectionManager.Open() line 1089 file c:\working\build_area\mapguide\3.1.0\x64\mgdev\server\src\common\manager\FdoConnectionManager.cpp (Cause: , Root Cause: ) StackTrace: - MgFeatureServiceHandler.ProcessOperation() line 83 file c:\working\build_area\mapguide\3.1.0\x64\mgdev\server\src\services\feature\FeatureServiceHandler.cpp - MgOpTestFeatureSourceConnection.Execute() line 100 file c:\working\build_area\mapguide\3.1.0\x64\mgdev\server\src\services\feature\OpTestFeatureSourceConnection.cpp - MgServerFeatureService.TestConnection() line 244 file c:\working\build_area\mapguide\3.1.0\x64\mgdev\server\src\services\feature\ServerFeatureService.cpp - MgFdoConnectionManager.Open() line 366 file c:\working\build_area\mapguide\3.1.0\x64\mgdev\server\src\common\manager\FdoConnectionManager.cpp -- View this message in context: http://osgeo-org.1560.x6.nabble.com/MS-SQL-Server-Spatial-Provider-Unable-to-Connect-tp5308288.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users