SQL 229 Error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gordon - 24 Jul 2007 15:42 GMT

Hi,

I'm getting the following error when I try to access any of the objects in
my SQL Server database:

Error 229: SELECT permission denied on object 'sysfiles', database
'Seviper', owner 'dbo'.

This error, or one similar to it, is occurring whenever I try to access
Tables, Views, Stored Procedures, Users, or any of the other objects. I see
nothing when I try to look at the tables in this database, not even the
system tables.

Can someone please help?

Thanks,

GDT

Reply to this Message

Erland Sommarskog - 24 Jul 2007 23:44 GMT

> I'm getting the following error when I try to access any of the objects in
> my SQL Server database:
[quoted text clipped - 8 lines]
>
> Can someone please help?

Apparently you are not logged in with very much permissions, least of
all db_owner permissions. Thus it is not "your" database. Try a different
login.

Where is this server? On your own machine or at a hosting provider?
Somewhere else?

If there is an admin for this server, talk to that person. If you are
the admin for your server, please give us more details on how you
log in etc.

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Reply to this Message