admin cannot login and install error Cannot find the object "dbo.ProjectRoles - Installation problems - BugNET

BugNET Forums

Forum Support Installation pr... admin cannot login and install error Cannot find the object "dbo.ProjectRoles

Previous

Next

New Post

5/9/2007 8:54 AM

	Odiggity
26 posts

Re: admin cannot login and install error Cannot find the object "dbo.ProjectRoles

I found that there is not a dbo.ProjectRoles in the database, no problem there. It will not allow anyone to login with the admin/password account.

Perms have been given on the directory for IUSR and ASPNET (XPsp2 w/ IIS6)

New Post

5/9/2007 8:59 AM

	admin
645 posts
bugnetproject.com

Re: admin cannot login and install error Cannot find the object "dbo.ProjectRoles

Odiggity wrote
I found that there is not a dbo.ProjectRoles in the database, no problem there. It will not allow anyone to login with the admin/password account.

Perms have been given on the directory for IUSR and ASPNET (XPsp2 w/ IIS6)

I am still confused if you are donig an upgrade or a new install. From the looks of it you are upgrading?

Davin Dubeau
BugNET - Core Developer

New Post

5/9/2007 10:18 AM

	Odiggity
26 posts

Re: admin cannot login and install error Cannot find the object "dbo.ProjectRoles

I've been getting the SVN updates and I assumed that it did not need updating (install.aspx). I just (45 mins ago) wiped the whole directory and re-downloaded the code source from https://svn.sourceforge.net/svnroot/bugnet/trunk, re-added the perms for ASPNET on the directory, re-added the virtual directory in IIS and attached the MDF to SQL Express 2005. After starting the project, the login screen will come up, but after entering in the user/password (admin/password), it says that the login is invalid. I can only guess that the user/password for admin on the SVN DB has been reset or something. Next, I tried to run the Install.aspx, thinking it needed to be updated and received errors that others have posted already along the line of *.sql not available or dbo.ProjectRoles not available.

So, I wiped the App_Data folders *.MDF and *.LDF, went into SQL Express and created a blank DB called BugNetTest (as called in the web.config). Finally, I ran the Install.aspx and it has rebuilt the tables/procs/perms and is now letting me login under the admin. There are not any test projects or anything that I'm used to working with, but it's running.

I'm willing to try and download or update/restore the MDF from the SVN if you would like me to test or get the specific errors that I've received. I'm sure most of this has been a PEBKAC, but I try.

Thanks, Oddigity

New Post

7/4/2007 2:50 AM

	rizvan
6 posts

Re: admin cannot login and install error Cannot find the object "dbo.ProjectRoles

i try to insert the default admin and password i cannot login and i see Your login attempt was not successful. Please try again.
Could you help me to fix this issue?

How can i solve this pproblem.

New Post

7/17/2007 7:25 AM

	Odiggity
26 posts

Re: admin cannot login and install error Cannot find the object "dbo.ProjectRoles

Suggestions:
-if using SQL 2005, check if Shared memory is enabled and in the web.config verify that User Instance=True
-if not using shared memory, then set User Instance=False in web.config.

Page 2 of 2

Previous

Next

Installation pr...

admin cannot login and install error Cannot find the object "dbo.ProjectRoles

Forum Policy

These Discussion Forums are dedicated to the discussion of the BugNET issue tracker.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising.
2. No Flaming or Trolling.
3. No Profanity, Racism, or Prejudice.
4. Site Moderators have the final word on approving/removing a thread or post or comment.
5. English language posting only, please.