Question

After upgrading from 7.1.8 to 8.3.42 I get the message

The FogBugz database is down or could not be found.

Error: -2146232009: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

The sConnectionString value in the registry has the following value, for which the server and database are correct:

Server=S15360249\RS001;Initial Catalog=fogbugz;Integrated Security=SSPI;MultipleActiveResultSets=true;

I get the same error if I completely remove the sConnectionString entry.

Any ideas?

Case FC2012361

Answer 1

This error means that FogBugz is not able to connect to the database. There can be a number of reasons for this, but after an upgrade, if the sConnectionString value in the registry is correct, the problem is most likely that FogBugz is looking for its registry keys in the wrong place. If you are on a 64-bit server, the correct keys are in the Wow6432Node and the site in IIS is running 64-bit, or vice-versa.

For a machine that's running Windows 2008 on a 64 bit machine, the easiest way to fix this is to toggle the 32/64 bit setting in IIS for the application pool that FogBugz is running under.

In IIS Manager, go to Application Pools, and for the FogBugz application pool, click Advanced Settings. Under the General section, switch the "Enable 32-Bit Applications" setting to the opposite value, and click OK.

Answer 2

I would strongly suggest getting in touch with FogCreek directly, either via email or a phone call. (the contact info is the the footer of this page)

Also, please post back the solution once you resolve the issue because someone else might run into the same issue.