It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage


I have created NEW DB in SQL 2014 for JIRA Installation. 

Based on below document,

How to create a Schema in DB. 

Create an empty 'schema' in the database for the Jira tables  (e.g. jiraschema).

1 answer

1 accepted

0 votes
Answer accepted
Alexis_Robert Community Leader Oct 21, 2019

Hi @Chandramouli_Bollareddy , 


you can follow this script to create the schema and all the other settings for SQL Server :


Let me know if this helps, 



Hi @Alexis_Robert 

I have one more Query: 

In this SQL server 2014, We have JIRA, Confluence, BitBucket and etc databases available. 

For New Installation of JIRA (New Linux Server), We will create a NEW DB(Atl_Jira)  in SQL 2014 Server (Existing Server). 

In this server, we have "jirauser" and "jirascheme" available for existing DB of JIRA, Confluence and etc. 

So, Shall i create New JIRAUSER and JIRASCHEME for new JIRA installation for NEWDB in Existing SQL Server. 

Or shall i user earlier JIRAUSER and JIRASCHEME?

Like Madà_Miesen likes this
Alexis_Robert Community Leader Oct 21, 2019



you should create a new user and password.

Like Chandramouli_Bollareddy likes this

Hi @Alexis_Robert 


We have  JIRAUSER and JIRASCHEME for Existing databases. 

Can i use same jirauser and jiracheme for new DB or create new one.

Hi @Alexis_Robert 


We have JIRAUSER(dbo) and JIRASCHEME (jiraseheme) for existing database. 

Can i use same name for JIRAUSER (dbo) and JIRAScheme  (jiraseheme) for new DB. 

or create new name?



Please reply to my query. 



I'm mid of work..please suggest us

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you