Fog Creek Software
Discussion Board




FogBUGZ Internal Error

After a routine server upgrade this weekend, FogBugz now gives the followng message when we try to display the List. This is with Windows 2000 and IIS 5. Hope you will respond ASAP since our bug tracking is now down.

An internal error occurred in FogBUGZ. Please report this error to Fog Creek Software by clicking "Submit."

File:     /FogBUGZ/CPerson.asp     
Line:     57     
Error:     Cannot open database requested in login 'fogbugz'. Login fails.     
Browser:     Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705; .NET CLR 1.1.4322)     
Number:     0x80004005     
Category:     Microsoft OLE DB Provider for SQL Server     
Column:     -1     
QueryString:     pg=pgList|57|80004005|Cannot_open_database_requested_in_login_'fogbugz'._Login_fails.     
URL:     /FogBUGZ/default.asp     
Content Length:     0     
Local Addr:     10.64.101.166     
Remote Addr:     10.64.101.166     
Time:     8/9/2004 9:05:57 AM

Howard Weisberg
Monday, August 09, 2004

Your upgrade changes have apparently broken the FogBugz user in IIS. I'd need more information to tell which requisite was removed, probably some permissions were removed in the name of "security".

You'll need to reset things to the way FB Setup had them:

http://www.fogcreek.com/FogBUGZ/KB/setup/WhatSetupDoes.html

Just look at the IIS Settings and the Grant Permissions and SQL Server Permissions sections. It's the login to the db that gets choked up.

You're using SQL Server, right? Did you make any changes on the SQL Server end?

http://www.fogcreek.com/FogBUGZ/KB/howto/DetermineUser.html

Dmitri
Fog Creek Software
Monday, August 09, 2004

Thanks for the info.

Somehow, someone changed a the property of the FogBugz database to "restrict access --  single user."

Don't know how but it's fixed now.

Howard Weisberg
Monday, August 09, 2004

*  Recent Topics

*  Fog Creek Home