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 vote

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 Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published 26m ago in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

7 views 0 2
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