What's your database configuration?
<entry key='database.driver'>com.microsoft.sqlserver.jdbc.SQLServerDriver</entry>
<entry key='database.url'>jdbc:sqlserver://NS652895\NELSON\DB:1433;databaseName=traccar;</entry>
<entry key='database.user'>user</entry>
<entry key='database.password'>password</entry>
Have you tried the config from our official documentation?
Thanks I've made the changes and it has connected to the SQL, but now I'm getting this error message in the log
2023-03-03 15:14:10 INFO: Operating system name: Windows Server 2019 version: 10.0 architecture: amd64
2023-03-03 15:14:10 INFO: Java runtime name: OpenJDK 64-Bit Server VM vendor: Eclipse Adoptium version: 17.0.6+10
2023-03-03 15:14:10 INFO: Memory limit heap: 30688mb non-heap: 0mb
2023-03-03 15:14:10 INFO: Character encoding: Cp1252 charset: windows-1252
2023-03-03 15:14:10 INFO: Version: 5.6
2023-03-03 15:14:10 INFO: Starting server...
2023-03-03 15:14:11 INFO: HikariPool-1 - Starting...
2023-03-03 15:14:11 INFO: HikariPool-1 - Added connection ConnectionID:1 ClientConnectionId: 8aebba81-1930-4d81-87f5-90589c341a33
2023-03-03 15:14:11 INFO: HikariPool-1 - Start completed.
2023-03-03 15:14:11 INFO: Set default schema name to dbo
2023-03-03 15:14:11 INFO: Clearing database change log checksums
2023-03-03 15:14:16 ERROR: Main method error - There is already an object named 'DATABASECHANGELOGLOCK' in the database. - SQLServerException (... < DatabaseModule:95 < <gener:-1 < *:-1 < ... < Main:126 < ...)
2023-03-03 15:14:16 WARN: JNA: Callback org.traccar.WindowsService$ServiceMain@82ea68c threw the following exception - There is already an object named 'DATABASECHANGELOGLOCK' in the database. - SQLServerException (... < DatabaseModule:95 < <gener:-1 < *:-1 < ... < Main:126 < ...)
Now it looks like you have some schema conflict.
What can I do in this case, sorry ?
I'm not sure. I think you're not telling us some context.
Hi, Im getting this error message in the log when I try to initial the traccar