Setup Database Microsoft SQL errors

[David Crouch]

I can't seem to make a connection from Confluence server to SQL for the database setup. This happens with both simple or with connection string although occasionally when using the connection string method it says no suitable driver

SQLState - S0001

Error Code - 18456

com.microsoft.sqlserver.jdbc.sqlserverexception: login failed for user xxxxx

ClientConnectionID:xxxx-xxx-xxx

[David Crouch · Accepted solution]

I ended up using a local SQL user account which worked for initial database connection, but failed during setup due to permissions it was looking for on windows NTFS security for atlassian program files. Only way I was able to get past that was to give everyone access to those program files since you can't add an sql user to windows side. Really crappy how SQL setup directions for confluence say sql user and you can't use windows authentication

[Alexis Robert]

Hi @David Crouch , 

it seems like it's an issue with your SQL user : you should ask you Database administrator if the password you have is correct,  as it looks like a simple authentication issue.

Let me know if this helps, 

--Alexis

[David Crouch]

I am the DBA. I'm using an admin account to test since I ran into same issues with the service account I setup for this. I have a feeling it's something to do with confluence and jdbc driver, like it doesn't know how to find it and I need to configure it to work with confluence. I vaguely recall something like this when setting up postgreSQL several years ago before our server got corrupted, but now due to corporate policies and software approval, I have to use SQL server.