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

[Angela Spranger]

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

[Janet Albion]

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.