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

Friday, April 1, 2011 9:45:02 AM

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 2:48:04 PM
Avatar
re: kagel on Friday, April 1, 2011 9:45:02 AM

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 8:25:52 AM
Avatar
re: inflectra.adam on 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 2:30:00 PM
Avatar
re: inflectra.adam on 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 11:16:38 AM
Avatar
re: inflectra.mike on 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 2:29:33 PM
Avatar
re: kagel on Tuesday, April 5, 2011
Good to hear, thanks!
Statistics
  • Started: Friday, April 1, 2011 9:45:02 AM
  • Last Reply: Wednesday, April 6, 2011 2:29:33 PM
  • Replies: 5
  • Views: 1331