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 <[email protected]> Sent: Thursday, April 25, 2019 4:50 PM To: Parker, Peter R (OIT) <[email protected]> Cc: [email protected] 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) <[email protected]<mailto:[email protected]>> 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=> [email protected]<mailto:[email protected]> 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 [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
