Book Image

Mastering Geoserver

By : Colin Henderson
Book Image

Mastering Geoserver

By: Colin Henderson

Overview of this book

Table of Contents (19 chapters)
Mastering GeoServer
About the Author
About the Reviewers

Serving data from Microsoft SQL Server and SQL Azure

GeoServer does not come with support for Microsoft SQL Server or SQL Azure out of the box. To enable support for Microsoft SQL Server databases as a source format, we need to install the GeoServer extension and supporting Microsoft JDBC drivers.

Installing the Microsoft SQL Server extension

To get support for Microsoft SQL Server as a data store, we need to install two components. First, we must install the GeoServer extension to enable the format, and then we need to install some supporting Microsoft files. Due to licensing restrictions, the GeoServer extension does not come with the necessary Microsoft JDBC driver files, and so, these will need to be installed separately.

We need to download the GeoServer extension for SQL Server, ensuring we choose the download matching the version of GeoServer that we installed. We have been using the current stable version (which at the time of writing is 2.5.2), so this is the version of the extension...