SQL Server Spatial FDO Provider - Installation Notes

Installing SQL Server 2008

For the install, make sure that you select the option to allow for both Windows and SQL Server Authentication.

Once SQL Server 2008 is installed, run SQL Server Configuration Manager (Start->Programs->SQL 2008->Config tools). Select 'Protocols for MSSQLSERVER' on the left (under SQL Server Network Configuration) and then enable the 'TCP/IP' protocol. You will have to restart the server after this, which you can do with this tool as well. Choose SQL Server Services on the left and restart SQL Server.

Setting up the provider.

At this time, until we build an actual install tool, what we’re doing to set this up for MapGuide 2009 and other clients is to replace the current SQL Server provider via the providers.xml file. Take the new dlls and drop them into the fdo bin directories for your client applications (e.g. C:\Program Files\Autodesk\MapGuideEnterprise2009\Server\Bin\Fdo on my machine). Update the providers.xml file in those directories by finding the entry for the current SQL Server provider and modify the dll name. You can change the description as well to indicate 2008 if you want. Here is what it should look like after changing the dll name and description:

<FeatureProvider>
    <Name>Autodesk.SqlServer.3.3</Name>
    <DisplayName>Autodesk FDO Provider for SQL Server </DisplayName>
    <Description>Read/write access to feature data in a MS SQL Server 2008-based data store. Supports geospatial and nongeospatial data and schema R/W access. </Description>
    <IsManaged>False</IsManaged>
    <Version>3.3.0.0</Version>
    <FeatureDataObjectsVersion>3.3.0.0</FeatureDataObjectsVersion>
    <LibraryPath>SqlServerSpatialProvider.dll</LibraryPath>
  </FeatureProvider>

You may change the display name and description as well, but nothing else. Now, after installing the new dll's as described above, you can run MG 2009 or other clients based on FDO 3.3. Connect to 'localhost' and use the sa user and pwd that you defined when installing SQL 2008 or other SQL Server user account that you created.