<br><span style="font-family: verdana,sans-serif;">Forgot to add - I am able to successfully create a Dataconnection to a shapefile that I added to MGOS.</span><br style="font-family: verdana,sans-serif;"><span style="font-family: verdana,sans-serif;">The problem seems to be specific to adding a Spatial SQL Server dataconnection.</span><br style="font-family: verdana,sans-serif;">
<br><div class="gmail_quote">On Thu, Jun 10, 2010 at 10:59 AM, David Collins <span dir="ltr"><<a href="mailto:david.8.collins@gmail.com">david.8.collins@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<span style="font-family: verdana,sans-serif;">Hello.</span><br style="font-family: verdana,sans-serif;"><br style="font-family: verdana,sans-serif;"><b style="font-family: verdana,sans-serif;">MGOS 2.2.0.4829-Beta1<br>Maestro 2.0.0.4650<br>
Bundled Apache/PHP</b><br style="font-family: verdana,sans-serif;"><br style="font-family: verdana,sans-serif;"><span style="font-family: verdana,sans-serif;">I have downloaded the latest SQL Server Native Client, and installed it. (sqlncli.msi)</span><br style="font-family: verdana,sans-serif;">
<br style="font-family: verdana,sans-serif;"><span style="font-family: verdana,sans-serif;">Immediately after starting Maestro and successfully connecting to MGOS 2.2, I try to create a new Spatial SQL Server 'Dataconnection', I enter the details - SQL Server name\instance, database & credentials</span><br style="font-family: verdana,sans-serif;">
<br style="font-family: verdana,sans-serif;"><span style="font-family: verdana,sans-serif;">When I click </span><b style="font-family: verdana,sans-serif;">'Test Connection'</b><span style="font-family: verdana,sans-serif;">, I get the following ..</span><br style="font-family: verdana,sans-serif;">
<span style="font-family: verdana,sans-serif;">The remote server returned an error: (559) MgConnectionFailedException.: </span><br style="font-family: verdana,sans-serif;"><span style="font-family: verdana,sans-serif;">Problem:\nCannot establish connection to the MapGuide Server.\n\nPossible Causes:\n-Your session has been idle for too long;\n-MapGuide Server is no longer responding;\n-Internet connection problems.\n\nSolution:\nRestart your application / session, restart the MapGuide Server service, or contact with the server administrator.</span><br style="font-family: verdana,sans-serif;">
<br style="font-family: verdana,sans-serif;"><span style="font-family: verdana,sans-serif;">I shutdown Maestro, restart MapGuide ...</span><br style="font-family: verdana,sans-serif;"><br style="font-family: verdana,sans-serif;">
<span style="font-family: verdana,sans-serif;">C:\GI\Doco>net stop "MapGuide Server 2.2"</span><br style="font-family: verdana,sans-serif;"><span style="font-family: verdana,sans-serif;">The MapGuide Server 2.2 service is stopping.</span><br style="font-family: verdana,sans-serif;">
<span style="font-family: verdana,sans-serif;">The MapGuide Server 2.2 service was stopped successfully.</span><br style="font-family: verdana,sans-serif;"><br style="font-family: verdana,sans-serif;"><span style="font-family: verdana,sans-serif;">C:\GI\Doco>net start "MapGuide Server 2.2"</span><br style="font-family: verdana,sans-serif;">
<span style="font-family: verdana,sans-serif;">The MapGuide Server 2.2 service is starting.</span><br style="font-family: verdana,sans-serif;"><span style="font-family: verdana,sans-serif;">The MapGuide Server 2.2 service was started successfully.</span><br style="font-family: verdana,sans-serif;">
<br style="font-family: verdana,sans-serif;"><span style="font-family: verdana,sans-serif;">Open Maestro, and do the same again, and get the same error.</span><br><br><span style="font-family: verdana,sans-serif;">Regards,</span><br style="font-family: verdana,sans-serif;">
<font color="#888888">
<span style="font-family: verdana,sans-serif;">David</span><br style="font-family: verdana,sans-serif;"><br>
</font></blockquote></div><br>