SQL error - Installation problems

BugNET Forums

Forum Support Installation pr... SQL error

10/11/2006 1:35 PM

	jbcobb
2 posts

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 6:07 AM

	admin
621 posts
bugnetproject.com

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
BugNET - Core Developer

10/17/2006 12:37 AM

	jbcobb
2 posts

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

Support

Installation pr...

SQL error

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.