Setup - Getting "user is not associated with a trusted sql server connection"

[Robert Blake]

During initial setup, pointing to my SQL Server, which is running on the same box as Jira. Get the error "User is not associated with a trusted SQL Server connection." Anyone have any ideas?

[Renjith Pillai]

And remember JIRA does not support Windows based authentication to SQL server. You need to have mixed mode authentication enabled in SQL server and also the user used should be an SQL user.

Point 6 on this documentation.

[Arthur Gonçalves]

Hello Robert,

As per this article from Microsoft Knowledge Base, it sounds like that either the user that you're trying to connect to the database doesn't have the necessary privileges or its login doesn't exist. Could you please double check the security settings on the database and the necessary accesses for this user?

Cheers!