Unable to link FishEye with a SQL DataBase

[Yannick Morin-Rivest]

We are installing all the Atlassian product, and i am trying to configure FishEye properly. Here are the steps I am doing:

1- install new instance of fisheye-crucible

2- Run trough the wizard

3- Go to the database settings in the admin panel

4- Insert my db information

5- Test the connection, connection succeeded

6- Save&Migrate then i get :

Started

Starting ActiveObjects backup...

* Backing up Database Information

* Backing up Table Definitions

** Table count: 0

* Backing up Tables

ActiveObjects backup completed!

Creating table definitions...

Problem with create tables script C: atlassian-fisheye-crucible sql SQLSERVER2008 schema tables_76.sql

Database migration failed: com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script C: atlassian-fisheye-crucible sql SQLSERVER2008 schema tables_76.sql

I tried with both the bundle driver or the one we used for crowd and i tried with both fisheye or crucible installer... no differences

[Yannick Morin-Rivest · Accepted solution]

The problem was resolved by Atlassian support, just posting the result here:

The SQL database was created the same way jira's and crowd where created. The only difference is that you need to migrate the default in memory database in fisheye, so the default fisheye user must be granted rights to create table.

Hope that this can help someone else !