This question is in reference to Atlassian Documentation: Database Setup for SQL Server
I am using the jtds drivers, version 2.2 as recommended. I have a SQL Server 2012 Express installation. I put the jar file in the confluence/lib folder and restarted the service. Here are my settings:
Driver Class Name: net.sourceforge.jtds.jdbc.Driver
Database URL: jdbc:jtds:sqlserver://localhost:1433/Confluence
User Name: *********
Password: **********
I have given my sql user every possible role for the Confluence database:
image2015-10-30 9:29:39.png
Yet I still get the following error:
image2015-10-30 9:27:19.png
The following error(s) occurred:
I changed the url to `jdbc:jtds:sqlserver://localhost:1433/Confluence;instance=./EXPRESS` and now I get a different error: `java.sql.SQLException: Unable to get information from SQL Server: localhost.`
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.