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.
Please do the following:
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.
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.
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot