{"action":"created","issue":{"url":"https://api.github.com/repos/tananaev/traccar/issues/1525","labels_url":"https://api.github.com/repos/tananaev/traccar/issues/1525/labels{/name}","comments_url":"https://api.github.com/repos/tananaev/traccar/issues/1525/comments","events_url":"https://api.github.com/repos/tananaev/traccar/issues/1525/events","html_url":"https://github.com/tananaev/traccar/issues/1525","id":116592423,"number":1525,"title":"Connecting to MS SQL Express","user":{"login":"sammy1000","id":15820024,"avatar_url":"https://avatars.githubusercontent.com/u/15820024?v=3","gravatar_id":"","url":"https://api.github.com/users/sammy1000","html_url":"https://github.com/sammy1000","followers_url":"https://api.github.com/users/sammy1000/followers","following_url":"https://api.github.com/users/sammy1000/following{/other_user}","gists_url":"https://api.github.com/users/sammy1000/gists{/gist_id}","starred_url":"https://api.github.com/users/sammy1000/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sammy1000/subscriptions","organizations_url":"https://api.github.com/users/sammy1000/orgs","repos_url":"https://api.github.com/users/sammy1000/repos","events_url":"https://api.github.com/users/sammy1000/events{/privacy}","received_events_url":"https://api.github.com/users/sammy1000/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-11-12T16:58:15Z","updated_at":"2015-11-12T18:43:17Z","closed_at":null,"body":"Hi Anton,\r\nBeen trying to connect traccar server to sqlexpress on local machine and had followed all steps to best of my knowledge, but I am sure I am missing something because traccar server cannot connect with sqlexpresss as in the reported message in wrapper log:\r\n\r\n<pre>WARN com.mchange.v2.c3p0.DriverManagerDataSource - Could not load driverClass com.microsoft.sqlserver.jdbc.SQLServerDriver</pre>\r\n\r\nThis is the database configuration entries in traccar.xml:\r\n\r\n\t<entry key='database.driverFile'>C:\\Program Files (x86)\\Traccar\\lib\\sqljdbc42.jar</entry> \r\n\t<entry key='database.driver'>com.microsoft.sqlserver.jdbc.SQLServerDriver</entry> \r\n\t<entry key='database.url'>jdbc:sqlserver://MAIN-PC\\SQLEXPRESS;user=traccar;password=traccar;</entry> \r\n\t<entry key='database.user'>traccar</entry> \r\n\t<entry key='database.password'>traccar</entry>\r\n\r\nIs this an issue with JDBC driver not being loaded, and if so, what should I do to correct it. Or should I look for other possible issues I may have in my setup.\r\nAppreciate your help ...\r\n\r\nThanks,\r\n"},"comment":{"url":"https://api.github.com/repos/tananaev/traccar/issues/comments/156197399","html_url":"https://github.com/tananaev/traccar/issues/1525#issuecomment-156197399","issue_url":"https://api.github.com/repos/tananaev/traccar/issues/1525","id":156197399,"user":{"login":"tananaev","id":1161863,"avatar_url":"https://avatars.githubusercontent.com/u/1161863?v=3","gravatar_id":"","url":"https://api.github.com/users/tananaev","html_url":"https://github.com/tananaev","followers_url":"https://api.github.com/users/tananaev/followers","following_url":"https://api.github.com/users/tananaev/following{/other_user}","gists_url":"https://api.github.com/users/tananaev/gists{/gist_id}","starred_url":"https://api.github.com/users/tananaev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tananaev/subscriptions","organizations_url":"https://api.github.com/users/tananaev/orgs","repos_url":"https://api.github.com/users/tananaev/repos","events_url":"https://api.github.com/users/tananaev/events{/privacy}","received_events_url":"https://api.github.com/users/tananaev/received_events","type":"User","site_admin":false},"created_at":"2015-11-12T18:43:17Z","updated_at":"2015-11-12T18:43:17Z","body":"You are using Java 8 driver. I guess it could be the problem. Try to use `sqljdbc41`; it's the one for Java 7."}}