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 ...

Get Mastering GeoServer now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.