Jira + SQL Server 2008 R2: The user is not associated with a trusted SQL Server connection.

I followed the instructions for "Connecting to an External DB".


I tried uploading a screen shot of the JIRA Setup screen, I'm not seeing any indication that it was uploaded for this post...

So, here's what I selected on the Setup screen:

Server Language: English (US)

Database Connection: External

Database Type: MS SQL Server

Hostname: CCD-129055R

Port: 1433

Database: Jira

Username: JiraDbUser

Password: <the pwd>

Schema: jiraschema

If I click "Next" or "Test Connection" I receive the following error:

Error connecting to database

Login failed for user 'JiraDbUser'. The user is not associated with a trusted SQL Server connection.

The resolution for this is supposedly to select "SQL Server and Windows Authentication mode", however, that option is already selected on my server.

Under Server Properties --> Security --> Server Authentication

"SQL Server and Windows Authentication mode" is selected

1 answer

0 votes
Janet Albion Atlassian Team May 22, 2013

Hi Angelas,

Other than the Server Authentication, there various possible root cause for this problem:

  • trailing space after database name or the username
  • bad network also possible cause this even though might be very rare due to communication between SQL server and Domain Controller are broken
  • to quote Microsoft "The login may use Windows Authentication but the login is an unrecognized Windows principal. An unrecognized Windows principal means that Windows can't verify the login. This might be because the Windows login is from an untrusted domain."
  • not able to resolve the Windows Account when trying to connect to the SQL server. Two possible reason for this are . a) a local account on that machine is being used for making the connection to the SQL Server instance instead of using a domain account. So, both Domand Controller and SQL server can't recognise this local account b)if there is IIS running between JIRA and SQL server, the account running IIS does not have the access to SQL server.

I think you can try to follow the resolution at SQL server KB http://support.microsoft.com/kb/555332 to fix the error entirely.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,121 views 13 19
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot