BugNET

I'm trying to upgrade from 0.7.881.0 to 0.7.942.0.

As a test run I copied our main BugNet DB to a development server and tried to do the upgrade there to test it before trying it on a production system. I've got the new files copied over, and my web.config updated with the same ConnString, MachineKey, Install Date, etc. IIS config (security settings, etc) is the same on both servers. I'm not currently using active directory (will use that once this issue is resolved)... just the bugnet built in user/role security system.

I can't seem to log into bugnet now. I've made sure that my MachineKey is the same so that the decryption of the password is done properly. I just keep getting a "Your login attempt was not successful. Please try again." error. In the event log i get a "Membership credential verification failed." error when the login fails. I can however see my projects and bugs listed on the homepage and click into them. I just can't log in. I get a " An error occured sending the password reminder." when i try to recover my password.

What else can I try? I've compared the web.config of the working install with that of the newer 0.7.881.0 build and the config is mostly the same even if some sections exist in the new web.config that didn't in the old one.

The connection string is correct. I tried going into IIS and setting the application name to "BugNET" as you suggested.

In your upgrade from 0.7.x upgrade instructions I try to do the last step to run the install.aspx page and i keep getting these errors. I've verified that the database user account has full permission to that database. It looks like it is trying to incrimentally upgrade the DB... first to v 0.7891.0 then to .07.921.0 where it fails.

Any ideas what the problem might be?

Upgrading To Version: 0.7.942.0

Running Upgrade Script: 0.7.891.0.SqlDataProvider - 00:00:00.0156251
Running Upgrade Script: 0.7.921.0.SqlDataProvider - 00:00:00.1406259
Error!

Error in file:C:\BugNetDev\Install\dbscripts\0.7.921.0.SqlDataProvider.sql
Message:Cannot drop the procedure 'dbo.chObjOwner', because it does not exist or you do not have permission.


Running Upgrade Script: 0.7.942.0.SqlDataProvider - 00:00:00.3437522
Error!

Error in file:C:\BugNetDev\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:There is already an object named 'FK_Bug_Component' in the database. Could not create constraint. See previous errors.


Error!

Error in file:C:\BugNetDev\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Bug_FixedInVersionId". The conflict occurred in database "BugNET", table "dbo.Version", column 'VersionID'.


Error!

Error in file:C:\BugNetDev\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:There is already an object named 'FK_Bug_Priority' in the database. Could not create constraint. See previous errors.


Error!

Error in file:C:\BugNetDev\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:There is already an object named 'FK_Bug_Project' in the database. Could not create constraint. See previous errors.


Error!

Error in file:C:\BugNetDev\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:There is already an object named 'FK_Bug_Resolution' in the database. Could not create constraint. See previous errors.


Error!

Error in file:C:\BugNetDev\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:There is already an object named 'FK_Bug_Status' in the database. Could not create constraint. See previous errors.


Error!

Error in file:C:\BugNetDev\Install\dbscripts\0.7.942.0.SqlDataProvider.sql
Message:There is already an object named 'FK_Bug_Type' in the database. Could not create constraint. See previous errors.

That worked as far as upgrading the DB. Thanks!

I have another question regarding using windows authenticaion. I followed the installation/upgrade steps on your website but windows authentication is still not working. I made sure that IIS it NOT allowing anonymous access, IS using windows authentication, and have also checked the web.config to specify that windows authentication should be used. I added my user in the domian\username format as a super user. Anything else I can try? I followed the steps exactly with no luck.

THanks!