SQL Server 2014 installation

[Paul Schwaegerle]

I have used Jira in the past but this is my first time installing and administrating.  I have installed on Windows Server 2016 and using MSSQL 2016 as my database.  When Jira goes to create the database it errors out.  I am not sure where to start looking as to why it had an error.

Here is my database creation script if this would help:

CREATE DATABASE jira
GO
USE jira
GO
ALTER DATABASE jira SET ALLOW_SNAPSHOT_ISOLATION ON
GO
ALTER DATABASE jira SET READ_COMMITTED_SNAPSHOT ON
GO
ALTER DATABASE jira COLLATE SQL_Latin1_General_CP1_CS_AS
GO
SET NOCOUNT OFF
GO
USE master
GO
CREATE LOGIN jirauser WITH PASSWORD=N'jirapassword', DEFAULT_DATABASE=jira, CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
ALTER AUTHORIZATION ON DATABASE::jira TO jirauser
GO

Thanks

[Shannon S · Accepted solution]

Hi Paul,

Your title says 2014 but your description says you're using 2016. Can you confirm?

You'll want to create it exactly as in this article, using the SQL Manager:

• Connecting Jira Applications to SQL 2016

This way you can ensure the database is created correctly.

Let me know if you have any questions.

Shannon

[Paul Schwaegerle]

Sorry.  It is SQL 2014.

[Paul Schwaegerle]

I was able to find the SQL 2014 document and followed it and now I have my Jira up and running.

Thanks

[Shannon S]

You're welcome, Paul! Glad you were able to get up and running.

Regards,

Shannon