[mapguide-trac] #1378: Cannot connect to SQL Server 2008 - 2.2 Beta 1

[MapGuide Open Source]

#1378: Cannot connect to SQL Server 2008 - 2.2 Beta 1
-------------------------------+--------------------------------------------
   Reporter:  tybion           |       Owner:       
       Type:  defect           |      Status:  new  
   Priority:  low              |   Milestone:  2.2  
  Component:  Mapping Service  |     Version:  2.2.0
   Severity:  major            |    Keywords:       
External_id:                   |  
-------------------------------+--------------------------------------------

Comment(by tybion):

 More information ..[[BR]]
 It's taken most of the day, but I have managed to install SQL Server 2008
 Express within a VirtualBox session, so that I have a SQL 2008 Server that
 I can monitor.[[BR]]

 I can now confirm that MapGuide is successfully connecting to the SQL 2008
 Server at the same time that it reports the error -[[BR]]

 The remote server returned an error:(559) MgConnectionFailedException.:
 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.[[BR]]

 I have enabled the auditing of successful logins on SQL Server 2008, and I
 get the event -[[BR]]

 Login succeeded for user 'GEOL_DWH_TEST'. Connection made using SQL Server
 authentication. [CLIENT: 10.150.8.129][[BR]]

 .. where 10.150.8.129 is the address of the MapGuide server

-- 
Ticket URL: <http://trac.osgeo.org/mapguide/ticket/1378#comment:12>
MapGuide Open Source <http://mapguide.osgeo.org/>
MapGuide Open Source Internals