SELECT Permission denied. - Installing BugNET

Import Update!

We are currently in transition and have moved our discussions to CodePlex. These forums will remain as reference until we launch of our new site in the upcoming weeks. After that they will be removed.

Thank you for your patience during our transition.

Forums

Search Home All Forums

Home

Support

Installing BugN...

SELECT Permission denied.

9/3/2010 10:36 AM

Vancouver

Joined: 9/3/2010

Posts: 1

SELECT Permission denied.

I am new and trying to install BUGNET. I created a database in SQL 2008, added two users (bugnetadmin and ASPNET) and gave both dbo.Owner permission (actually I tried giving them ALL permissions).

Specified bugnetadmin in my connection string. I am still getting an error page. The first line says:

"The SELECT permission was denied on the object 'sysobjects' database 'mssqlsystemresource', schema 'sys'.

I ran the aspnet_regiis -ga aspnet etc.

I am kinda running out of ideas here.

9/3/2010 3:05 PM

Davin Dubeau

bugnetproject.com
Joined: 3/2/2006

Posts: 1428

Re: SELECT Permission denied.

Vancouver wrote:

I am new and trying to install BUGNET. I created a database in SQL 2008, added two users (bugnetadmin and ASPNET) and gave both dbo.Owner permission (actually I tried giving them ALL permissions).

Specified bugnetadmin in my connection string. I am still getting an error page. The first line says:

"The SELECT permission was denied on the object 'sysobjects' database 'mssqlsystemresource', schema 'sys'.

I ran the aspnet_regiis -ga aspnet etc.

I am kinda running out of ideas here.

Double check that the user has specific access to your BugNET database in sql server management studio. This is usually the cause because it is possible to create logins in sql server and not assign them to any database.

Davin Dubeau

Page 1 of 1

Home

Support

Installing BugN...

SELECT Permission denied.

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.