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
Hi Angelas,
Other than the Server Authentication, there various possible root cause for this problem:
I think you can try to follow the resolution at SQL server KB http://support.microsoft.com/kb/555332 to fix the error entirely.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.