MS SQL Server 2000 Startup errors

Please refer to our Knowledge Base article on the topic.

A user reports getting errors like these every time JIRA starts up:

JIRA functions correctly otherwise.

A solution is suggested in this jira-user post:

Hi Jason,

I have had the same errors when at startup that you are seeing.

The problem on my server was that when the user in my database ('JIRA')
created tables they were created as dbo.<tablename> and not
JIRA.<tablename>
so when JIRA attempts to verify a table JIRA.<tablename> exists it fails.
Then it tries to create <tablename>, but it already exists. All the
created
tables are owned by 'dbo' and not 'JIRA'.

I am running on Microsoft SQL Server so my fix may not fit exactly but this
is what I had to do:
Create the 'JIRA' user as a regular user of the JIRA database. Add the
JIRA user to the db_owner (database owner) role. (DO NOT change the database
owner to 'JIRA', just add the role!)

Of course, you will have to drop your existing database first.

Cheers,
Bradley.

We have also had reports from other users that there are also alternatives to this solution. The ddl_admin, db_datareader and db_datawriter roles could be used instead of db_owner role for the jirauser account.