SQL Server DataStore

This documentation is no longer maintained. Please see the new GeoServer documentation at http://docs.geoserver.org

This datastore is still experimental. If you experience any problems please report them to the mailing list: geoserver-users@lists.sourceforge.net

Installation

To install the SQL Server DataStore extension:

  1. Download the latest stable version. Or grab the latest nightly build.
  2. Unzip the archive info the WEB-INF/lib directory of the GeoServer installation.
  3. Download the SQL Server JDBC driver from Microsoft. The current tested version of the driver is version 1.2 (SQL Server 2005).
  4. Copy the driver into the WEB-INF/lib directory of the GeoServer installation.

Verifying the Extension Install

To verify the extension is installed correctly:

  1. Visit http://localhost:8080/geoserver/config/data/store.do
  2. Click the New button.

If "Microsoft SQL Server" is available as an option in the drop down the extension is installed correctly.

Using the Extension

Configuring a SQL Server data store is similar to configuring other datastores. See 2 DataStore Config for more information.

Troubleshooting

Added by Justin Deoliveira, last edited by Justin Deoliveira on Mar 12, 2009  (view change)
View Attachments (0) Info