[mapguide-users] MapGuide 3.0 ODBC connection SQL Server

[Scott Hameister]

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.gistec at 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 at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapguide-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20190527/f2f3000f/attachment.html>