{"id":1607,"date":"2013-08-02T18:08:42","date_gmt":"2013-08-02T16:08:42","guid":{"rendered":"http:\/\/www.switchbl8.nl\/blog\/?p=1607"},"modified":"2013-08-02T18:08:42","modified_gmt":"2013-08-02T16:08:42","slug":"geoserver-on-linux-to-serve-sqlserver-data","status":"publish","type":"post","link":"https:\/\/www.switchbl8.nl\/blog\/2013\/08\/geoserver-on-linux-to-serve-sqlserver-data\/","title":{"rendered":"GeoServer on Linux to serve SQLServer data"},"content":{"rendered":"<p>I never knew that there was Linux support for SQLServer, but it turns out that there is a <a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=11774\" title=\"Download JDBC 4.0 for SQL Server\" target=\"_blank\">JDBC 4.0 driver<\/a> for it that can be used in GeoServer.<\/p>\n<p>From the download, put sqljdbc4.jar in the tomcat\/lib directory if you only want JNDI connections, or in the GEOSERVER\/WEB-INF\/lib directory if you want connections that can be defined in GeoServer as well.<br \/>\nDownload the sqlserver plugin for GeoServer, and put the jar file (in my case gt-jdbc-sqlserver-9.3.jar) into the GEOSERVER\/WEB-INF\/lib directory.<\/p>\n<p>Now restart Tomcat (or just the GeoServer webapp if you don&#8217;t want JNDI connections). Now create a new store. Be sure to open up port 1433 on your Windows firewall, or otherwise GeoServer can&#8217;t reach it.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I never knew that there was Linux support for SQLServer, but it turns out that there is a JDBC 4.0 driver for it that can be used in GeoServer. From the download, put sqljdbc4.jar in the tomcat\/lib directory if you only want JNDI connections, or in the GEOSERVER\/WEB-INF\/lib directory if you want connections that can <a href='https:\/\/www.switchbl8.nl\/blog\/2013\/08\/geoserver-on-linux-to-serve-sqlserver-data\/' class='excerpt-more'>[&#8230;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[58,61,109,137,108],"class_list":["post-1607","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-geoserver","tag-java-2","tag-jdbc","tag-linux","tag-sqlserver","category-1-id","post-seq-1","post-parity-odd","meta-position-corners","fix"],"_links":{"self":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts\/1607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/comments?post=1607"}],"version-history":[{"count":1,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts\/1607\/revisions"}],"predecessor-version":[{"id":1608,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/posts\/1607\/revisions\/1608"}],"wp:attachment":[{"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/media?parent=1607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/categories?post=1607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.switchbl8.nl\/blog\/wp-json\/wp\/v2\/tags?post=1607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}