Complaining about jiradbuser

How to resolve the problem of no connection btw windows server and sql server due to the complaining about jiradbuser ?

I got "Error connecting to database,  Login failed for user 'jiradbuser' " during database configuration after a brand new jira startup. 

the database actually used by windows7 and high sierra , no complain regarding 'jiradbuser'. 

jiradbuser is the user we use to access jiradb which is for jira software server version launch. 

1 answer

0 votes

Hi Quan,

  • Is this a local db user or a domain user?
  • Are you able to login to the Server Management Studio console with the jiradbuser?

Please do the following:

  1. Verify the username and password used in the JDBC driver definition.
  2. Ensure that the DBMS user exists and the permissions granted are sufficient.

 

If you're trying to connect to a MS SQL database that is running on a port that is not the default (non-standard), please take a look through this MSDN blog on tips for making application connectivity work.

If this is a domain user take a look at Setup "Windows-based" (Active Directory) authentication with SQL Server.

Cheers,

Branden

Thank you so much! I will raise these questions to our internal support on server side. 

Yes, the database user has been used many ways, but never with Windows servers + SQL servers. right now, we are installing jira software on a windows server. 

local db user ,  yes

domain user, not sure

windows server connecting to sql server, may require domain user access, that's where we stuck. 

HI, @Branden McElveen,   do I need to adjust dbconfig.xml to deal with windows server calling sql server ? 

such as "You may need to add the useNTLMv2=true property depending on your environment configuration."

our windows server admin just provided a VM to me, our SQL server admin just provided me SQL Authentication, which working perfectly, but not with windows server.

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

2,932 views 12 18
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