error "in sysdatabases no entry was found for database SpiraTeam" during installation

Friday, April 1, 2011
Avatar

we would like to reinstall Spira V3.0 on a PC having SQL Server 2005 Express preinstalled.

During the installation "in sysdatabases no entry was found for database SpiraTeam" occurs,

the installation is then stopped.

The error appeared also after a complete reinstallation of SQLServer. Any idea ?

5 Replies
Friday, April 1, 2011
Avatar
re: kagel Friday, April 1, 2011

Usually that means it could not create the database successfully.

Can you verify that the database user that you are using is either the SA account, a Windows Administrator (if using Windows Authentication) or an SA-equivalent account.

Also if you open up C:\Users\[User Name]\AppData\Local\Inflectra you will see an installation log for the system. Are there any errors messages in the log file?

Monday, April 4, 2011
Avatar
re: inflectra.david Friday, April 1, 2011

Sorry, I put this thread in the wrong forum, it concerns SpiraTeam, could you move it ? Otherwise I can reenter it in the SpiraTeam Section. Maybe that's why I haven't found the logfile dir you indicated to me?

In the meantime, some additional info: I configure the windows authentication option on creating the database. Using the SqlServer Management Studio Express I'm able to create any SQL Server DB

with this account. Until some week ago I have been able to install Spira, so I'm wondering what goes wrong now?

Monday, April 4, 2011
Avatar
re: inflectra.david Friday, April 1, 2011
The log file directory should still exist. If your web server operating system is pre-2008, then the directory should be:

C:\Documents and Settings\<user data>\Local Settings\Application Data\Inflectra

In is will be several folders, look for the install directory, and there should be several log files in there.

Thanks.
Tuesday, April 5, 2011
Avatar
re: inflectra.steve Monday, April 4, 2011

This hint was efficient, thanks:

++++log++++

Error Occured: Fehler bei CREATE DATABASE. Einige angezeigte Dateinamen konnten nicht erstellt werden. +£berpr++fen Sie zugeh+¦rige Fehler.
Die Datei 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SpiraTeamLog.ldf' kann nicht erstellt werden, da sie bereits vorhanden ist. +ändern Sie den Dateipfad oder den Dateinamen, und wiederholen Sie den Vorgang.

++++log++++

We had still ldf files in the sql data directory from former installations, after having deleted them, it worked,

Wednesday, April 6, 2011
Avatar
re: kagel Tuesday, April 5, 2011
Good to hear, thanks!

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

 

Statistics
  • Started: Friday, April 1, 2011
  • Last Reply: Wednesday, April 6, 2011
  • Replies: 5
  • Views: 3573