Thanks so much Matt that appears to be the problem. I installed using the 7.2
version of the mssql driver and now the MSSQL source appears in the Stores.
Peter
From: Matt Barclay
Sent: Thursday, April 25, 2019 4:50 PM
To: Parker, Peter R (OIT)
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] SQL Server Store
Hi Peter,
I just started using SQL Server with GeoServer (2.15.0). What worked for me
was grabbing the latest MS JDBC driver:
https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-2017<https://urldefense.proofpoint.com/v2/url?u=https-3A__docs.microsoft.com_en-2Dus_sql_connect_jdbc_download-2Dmicrosoft-2Djdbc-2Ddriver-2Dfor-2Dsql-2Dserver-3Fview-3Dsql-2Dserver-2D2017&d=DwMFaQ&c=teXCf5DW4bHgLDM-H5_GmQ&r=aDsvoX6vBhT-w3GOO3iFKqQq084QGkTNlkhqMq5w7Eg&m=VkFBOFLSW4d60HM4sRb6xYeRk-jiU42s3_NRmLqtMOM&s=IkAcCcAU8f0pY-Uz-bSqBjsxXIZM_2S2WU240voBqaI&e=>
Make sure that goes in your webapps/geoserver/WEB-INF/lib directory along side
the gt-jdbc-sqlserver extension. After a restart, you should see SQL Server on
the "Add new Store" page.
But also check your console log to see if there are any exceptions being thrown
due to missing libraries. I hit more than a few issues where the MS JDBC
driver wanted some other library installed.
Regards,
Matt
On Thu, Apr 25, 2019 at 1:35 PM Parker, Peter R (OIT)
mailto:peter.par...@alaska.gov>> wrote:
Using GeoServer 2.14.3 running on RedHat Linux. Installed the appropriate SQL
Server Drivers (sqljdbc42.jar and gt-jdbc-sqlserver-20.3.jar ) but when I go to
the Stores Admin in the UI I do not see an option for MS SQL Server.
I use Oracle as well and with those driver installed, I see the Vector
Datasource for Oracle in the Stores – New data source page.
Any ideas why I am not seeing the SQL Server option? Thank you! Peter
___
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ianturton.com_talks_foss4g.html-23_&d=DwMFaQ&c=teXCf5DW4bHgLDM-H5_GmQ&r=aDsvoX6vBhT-w3GOO3iFKqQq084QGkTNlkhqMq5w7Eg&m=VkFBOFLSW4d60HM4sRb6xYeRk-jiU42s3_NRmLqtMOM&s=fT08HLd7Wbsm_F-sOhw9X0vTp422Wjs-s0DROCwSCqc&e=>
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html<https://urldefense.proofpoint.com/v2/url?u=http-3A__geoserver.org_comm_userlist-2Dguidelines.html&d=DwMFaQ&c=teXCf5DW4bHgLDM-H5_GmQ&r=aDsvoX6vBhT-w3GOO3iFKqQq084QGkTNlkhqMq5w7Eg&m=VkFBOFLSW4d60HM4sRb6xYeRk-jiU42s3_NRmLqtMOM&s=ugGRTwDs6MwkAKprHMgGCNWXIGpUKoNdqZSaACETy5Q&e=>
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_geoserver_geoserver_wiki_Successfully-2Drequesting-2Dand-2Dintegrating-2Dnew-2Dfeatures-2Dand-2Dimprovements-2Din-2DGeoServer&d=DwMFaQ&c=teXCf5DW4bHgLDM-H5_GmQ&r=aDsvoX6vBhT-w3GOO3iFKqQq084QGkTNlkhqMq5w7Eg&m=VkFBOFLSW4d60HM4sRb6xYeRk-jiU42s3_NRmLqtMOM&s=j1_ctFv9Oi8HOfvDD57IZIZMP3p85xFAc_54PiJozHE&e=>
Geoserver-users@lists.sourceforge.net<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users<https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.sourceforge.net_lists_listinfo_geoserver-2Dusers&d=DwMFaQ&c=teXCf5DW4bHgLDM-H5_GmQ&r=aDsvoX6vBhT-w3GOO3iFKqQq084QGkTNlkhqMq5w7Eg&m=VkFBOFLSW4d60HM4sRb6xYeRk-jiU42s3_NRmLqtMOM&s=QF3K8pXjpXc4546Q0qc0zBQeQmdz6QnVu2gftfKjb6g&e=>
___
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
