FogBugz Technical Support

A forum for technical support discussion related to Fogbugz.
The current FogBugz Knowledge Base can be found at http://help.fogcreek.com/fogbugz.

Posts by Fog Creek Employees are marked:

Documentation
Release Notes
Network Status

Maintenance Service Install error

Dear Support,

We just purchased Fogbugz for Windows and installed on Windows 2003 Server with SQL 2005 on another server. We are using domain account. The Fogbugz site shows the following error:

The Fog Creek Maintenance Service has reported an error. - Hide Notification

12/19/2008 2:39 PM (GMT+11:00): The Fog Creek Maintenance Service has reported an error. (13) Microsoft VBScript runtime error: Type mismatch

In the web server event log, it has the following error from FogBugz Search:

System.Data.OleDb.OleDbException: Cannot open database "fogbugz" requested by the login. The login failed.
  at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
  at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
  at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
  at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
  at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
  at System.Data.OleDb.OleDbConnection.Open()
  at FogUtil.Database.Connection.Open()
  at FogUtil.Database.Command.Execute()
  at FogUtil.Database.Setting.LoadSingle(String sKey, String sDefault)
  at FogUtil.Database.IndexFileFactory.get_ixGeneration()
  at FogUtil.Database.IndexFileFactory.GetGeneration()
  at FogUtil.Search.Index.get_Generation()
  at FogUtil.Search.Store.Directory.LoadReadonlyDirectory(DirectoryState state, String prefix)
  at FogUtil.Search.Index.LoadReadonlyDirectory()
  at FogUtil.Search.Index.get_IndexSize()

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

How could we fix this? Thanks!
Richard Xu Send private email
Thursday, December 18, 2008
 
 
Give the domain account full dbo privileges on your 'fogbugz' database on the other server.  That will take care of *one* of the errors.  The other one, we'll see if that helps it as well.
Michael H. Pryor Send private email
Friday, December 19, 2008
 
 
Thanks! I restarted FogBugz Maintenance Service and no more error in the Event Log. Does it mean all errors are fixed and I can delete the notification? How do I know it is working properly?
Richard Xu Send private email
Sunday, December 21, 2008
 
 
If no more errors are reported in the Event Viewer or in FogBugz, you should be good.
Rich Armstrong Send private email
Monday, December 22, 2008
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Powered by FogBugz Bug Tracking and Evidence-Based Scheduling.