Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Install to SQL Server says database is not empty. Why?

Allen Casteran
Allen Casteran
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
May 10, 2012

I had my IT Admin create a new database on our SQL 2008 R2 server and added a SQL User u_jira with db_owner role for that database. Nothing else was added or created in the DB.

When I run the installation and provide the SQL server details, the Test Connection returns with an error message that The database specified is not empty.

But it is as fr as I cn tell. What is this test checking to determine empty or not??

Answer
Watch
Like Be the first to like this
430 views

1 answer

1 vote
Allen Casteran
Allen Casteran
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
May 11, 2012

OK So after poking through some java code it appears that the test for DB objects is picking up the presense of the system objects if you use the dbo schema as recommended in the updated install notes relating to errors with Confluence.

You can not install jira with the dbo schema.

Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
TAGS
AUG Leaders

Atlassian Community Events

    See all events