[Geoserver-users] GeoServer, WMS, WFS and SQL Server 2008

I am looking at using GeoServer and SQL Server 2008 together. Can GeoServer
run as WMS, WFS, WFS-T for vector data in SQL Server 2008. Are there any
things to look our for in this matter? Any links on the subject?
--
View this message in context: http://www.nabble.com/GeoServer%2C-WMS%2C-WFS-and-SQL-Server-2008-tp23938336p23938336.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Hi Ian,

Yes, it can. Some links that may help:

The installation/instruction page:

http://docs.geoserver.org/1.7.x/user/data/sqlserver.html

A good trouble shooting email:

http://www.nabble.com/SQL-Server-2008-datastore-connection-td22461607.html

The most common issues seem to be:

* not specifying the dbname when connecting
* ensuring that your data has a proper SRID set on it. This is more a bug which has been reported here:

http://jira.codehaus.org/browse/GEOS-2997

Hope that helps.

-Justin

lanstorp wrote:

I am looking at using GeoServer and SQL Server 2008 together. Can GeoServer
run as WMS, WFS, WFS-T for vector data in SQL Server 2008. Are there any
things to look our for in this matter? Any links on the subject?

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.