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