Do you have SQL set up to accept IP traffic I think it's called Named Pipes?
On Mon, May 27, 2019, 8:12 AM sm.gistec <sm.gis...@gmail.com> wrote: > Hello all > I've this configuration > - Win 2008 R2 enterprise > - Mapguide 3.0 x64 in apache 2.4 > - FDO 3.9 > - SQL Server in another server in lan (192.168.0.4) > > I've tried to connect my mapguide to SQL server using ODBC fdo driver whit > this connection string > > Driver={SQL > Server};Server=192.168.0.4\SQLEXPRESS;Database=NAME;Uid=USER;Pwd=PASSWORD > > but, when i test connection maestro respond me this > > FDO Connection Status: > The remote server returned an error: (559) MgFdoException.: > An exception occurred in FDO component. > Error occurred in Feature Source > > (Session:efc0bc02-807a-11e9-8000-005056012ff4_en_MTI3LjAuMC4x0B100B0F0B0E//9b3a079e-5f9c-4098-a800-44ccae4f5128.FeatureSource): > An exception occurred in FDO component. > RDBMS: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not > exist or access denied. > [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). > > - MgFdoConnectionManager.Open() line 333 file > > c:\working\build_area\mapguide\3.0.0\x64\mgdev\server\src\common\manager\FdoConnectionManager.cpp > - MgFdoConnectionManager.CacheFdoConnection() line 1097 file > > c:\working\build_area\mapguide\3.0.0\x64\mgdev\server\src\common\manager\FdoConnectionManager.cpp > - MgFdoConnectionManager.Open() line 1089 file > > c:\working\build_area\mapguide\3.0.0\x64\mgdev\server\src\common\manager\FdoConnectionManager.cpp > (Cause: , Root Cause: ) > > - MgFeatureServiceHandler.ProcessOperation() line 83 file > > c:\working\build_area\mapguide\3.0.0\x64\mgdev\server\src\services\feature\FeatureServiceHandler.cpp > - MgOpTestFeatureSourceConnection.Execute() line 100 file > > c:\working\build_area\mapguide\3.0.0\x64\mgdev\server\src\services\feature\OpTestFeatureSourceConnection.cpp > - MgServerFeatureService.TestConnection() line 244 file > > c:\working\build_area\mapguide\3.0.0\x64\mgdev\server\src\services\feature\ServerFeatureService.cpp > - MgFdoConnectionManager.Open() line 366 file > > c:\working\build_area\mapguide\3.0.0\x64\mgdev\server\src\common\manager\FdoConnectionManager.cpp > > > The remote server returned an error: (559) MgFdoException. > > I've opened my firewalls inbound and outbound, i've insert the macaddress > of > the mapguide server in the white list connection SQL Server > > What I'm missing? > Someone help? > > Thank you > > > > -- > Sent from: > http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html > _______________________________________________ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users