[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):

 I did the following ..[[BR]]

 net stop "MapGuide Server 2.2"[[BR]]
 notepad C:\MapGuide\Server\bin\serverconfig.ini[[BR]]
 - modified LogsDetail line to ..[[BR]]
 LogsDetail =
 '''ResourceService:3,DrawingService:3,FeatureService:3,MappingService:3,RenderingService:3,TileService:3,KmlService:3,ServerAdminService:3,SiteService:3'''
 [[BR]]

 del c:\MapGuide\Server\Logs\*.log[[BR]]
 net start "MapGuide Server 2.2"[[BR]]
 Ran Maestro, Opened SQL Server data connection, Clicked 'Test
 Connection'.[[BR]]
 net stop "MapGuide Server 2.2" (to flush information to log files)[[BR]]

 This is the data connection ..[[BR]]

 <?xml version="1.0" encoding="utf-8"?>
 <FeatureSource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns:xsd="http://www.w3.org/2001/XMLSchema"
 xsi:noNamespaceSchemaLocation="FeatureSource-1.0.0.xsd">
   <Provider>OSGeo.SQLServerSpatial</Provider>
   <Parameter>
     <Name>Username</Name>
     <Value>fred</Value>
   </Parameter>
   <Parameter>
     <Name>Password</Name>
     <Value>password</Value>
   </Parameter>
   <Parameter>
     <Name>Service</Name>
     <Value>maittestsql\testsql2008</Value>
   </Parameter>
   <Parameter>
     <Name>DataStore</Name>
     <Value>geol_dwh_test</Value>
   </Parameter>
 </FeatureSource>

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