"Seegrid will be due for a migration to confluence on the 1st of August. Any update on or after the 1st of August will NOT be migrated"

How to enable Microsoft SQL Server 2005/2008 datasource in GeoServer


Related pages


This page is intended to describe all the technical aspects, which may arise when using Microsoft SQL Server datasource in GeoServer.

Microsoft SQL Server versions

Microsoft SQL Server 2005

Microsoft SQL Server 2005 is not natively supported by sqlserver plug-in for GeoServer (http://docs.geoserver.org/2.0.x/en/user/data/sqlserver.html) due to the lack of spatial features in the database. However, there's a trick exists that allows to add spatial features to various editions of Microsoft SQL Server 2005. The solution is based on open-source extensions and won't incur any additional costs. The technical solution to the problem is described here: GeoserverMsSqlServer2005Connectivity.

Microsoft SQL Server 2008

Microsoft SQL Server 2008 is supported natively by sqlserver plug-in for GeoServer. See more at http://docs.geoserver.org/2.0.x/en/user/data/sqlserver.html.

-- PavelGolodoniuc - 2010-01-29
Topic revision: r3 - 15 Oct 2010, UnknownUser

Current license: All material on this collaboration platform is licensed under a Creative Commons Attribution 3.0 Australia Licence (CC BY 3.0).