question

Katie 1 avatar image
Katie 1 asked

has anybody configured Jira to the sql server database?

all, i wonder if any one of you have configured jira to a sql server database? it will be great if anybody could share the experience of configuring it . How long it it take to get the application working hooked to SQL SERVER database. and also how to migrating the existing HSQL database Thanks
sql-server-2008configuration
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Oleg avatar image
Oleg answered
It looks like the [atlassian documentation][1] explains the migration steps pretty well. The only things to worry about are: - SQL Server has to be configured in "mixed mode" to allow both SSPI and SQL Server authentication - Named instances should lead to the url in the following format: url="jdbc:jtds:sqlserver://JUST\_THE\_SERVER\_NAME:PORT/DB\_NAME;instance=INSTANCE\_NAME" - The user name and password have to be present in the jira.xml file - It appears that jira user has to be a member of db\_owner role (very lovely) [1]: http://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+SQL+Server+2008 Oleg
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image WilliamD commented ·
Oh my god, db_owner!!! Could that be a migration requirement only, the user being dropped down to a "mere-mortal" setting afterwards? If not, that is quite shocking, considering....
0 Likes 0 ·
Oleg avatar image Oleg commented ·
@WilliamD Not sure about this one, and I am certainly glad I never had to work with this one, and hopefully never will :) The documentation states that "This database user should not be the database owner, but should be in the db\_owner role."
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
@WilliamD - Oh, I dunno. `db_owner` is a lot safer than the ownership requirements of some apps, such as Kaseya. Hmm. Yep - I'm still #2.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.