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".

https://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+SQL+Server+2008

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 Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,445 views 15 19
Read article

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