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

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