SQL error - 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

10/11/2006 12:35 PM

J Cobb

Joined: 10/11/2006

Posts: 2

SQL error

I'm getting the following error using SQL Server 2000. I created a database named "bugnet" and am using SQL authentication rather than Windows. I have tried to give full permissions to user bugnet on db bugnet, but it doesn't seem to be working. Please forgive my lack of knowledge here as I'm well-versed with mysql on linux, but MS SQL is a first for me.

Errors occured during the execution of this wizard.
Module Message
ExecuteSqlInFile Error in file:C:\BugNET\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:SELECT permission denied on object 'sysobjects', database 'bugnet', owner 'dbo'.

I tried giving user bugnet all permissions (except DRI which gives an error) on table sysobjects, but still no dice.

10/12/2006 5:07 AM

Davin Dubeau

bugnetproject.com
Joined: 3/2/2006

Posts: 1428

Re: SQL error

It is easiest done if you make the user account apart of the dbowner role instead of selectively giving permissions to objects.

Davin Dubeau

10/16/2006 11:37 PM

J Cobb

Joined: 10/11/2006

Posts: 2

Re: SQL error

It does seem to be part of db_owners role, here's what I'm looking at. Is this correct?

http://red5.gotdns.org/stuff/untitled.JPG

Page 1 of 1

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.