The Old FogBugz Forum - FogBUGZ Internal Error

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