nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need help creating the database on an external MS SQL Server for DB migration

Mark Ward_6jkmft

Hello All,

I'm attempting to create an Microsoft SQL 2016 server database for migrating the data from the internal (H2) database. Since I have very limited skills working in MS SQL, I have concerns when it comes to creating the database user account and schema necessary for JIRA external DB correctly. The Jira documentation for creating the SQL Server 2016 database is not very detailed.

Can anyone in the community point me to a more detailed instructions for setting up / creating the database which would help me get over this part of the migration?

Thanks in advance,

Mark

Accepted answers

Brant Schroeder

@Mark Ward - Is this the documentation you looked at https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-sql-server-2016-948232141.html

This is pretty specific and walks you through the process. Are there specific questions you have or gaps that you believe you found in the documentation?

All comments

Brant Schroeder

@Mark Ward - Is this the documentation you looked at https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-sql-server-2016-948232141.html

This is pretty specific and walks you through the process. Are there specific questions you have or gaps that you believe you found in the documentation?

Mark Ward_6jkmft

Yes. My questions concern sections 3 and 4.

When creating the schema in section 3, the wizard ask for an owner. I wasn't sure so I assigned it to the jiradbuser account.

Because of the way I configured the owner is section 3, I have to assume it covered the request for section 4. I am not sure if that is correct.

Thanks for the response

Brant Schroeder

@Mark Ward It should but I would still confirm that the user (jiradbuser) has access to the database.

Mark Ward_6jkmft

Update: Installed Jira JSM 416.1 on a fresh server (Win Srv 2019) and attempted to connect the DB to the previously mentioned SQL 2016 server. Installation seem to go well until the DB setup portion. I provided all of the DB information requested and successfully tested the connection. Once I proceeded past that point, received a large error message followed by an "http 503 error" when I refreshed the browser. I uninstalled and reinstalled the JSM app but the connection via browser still displays the 503 error. Any help or directions would be greatly appreciated. I can post the error if requested.

Mark

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-service-desk-server

jira-service-management

jira-service-management-server