URGENT! Permission denied on object 'sysobjects', database mydatabase, owner 'dbo'

I'm trying to connect to a database on a computer within the same network, using Visual Studio. NET, when I get the error above!

I'm using mixed authentification and I have created the user henrik, with all permissions granted.

regards,

henrik
LVL 1
henrikatworkAsked:
Who is Participating?
 
geotigerCommented:

Go to your SQL server enterprise manager to check whether you have granted select to 'public' (or to 'henrik' if you want to limit access to the table) for sysobjects table in master DB.
0
 
geotigerCommented:

You need to do both:

1. create logins under security
2. add the user to "mydatabase" and grant proper access


GT
0
 
henrikatworkAuthor Commented:
I already did that, I've given the user full access to both the master database and myDatabase. Any ideas?

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
geotigerCommented:

Could you tell me what login name associated with dbo database user in both master and mydatabase?

Have you granted db_ower role to the database user?

GT
0
 
henrikatworkAuthor Commented:
Dbowner (for all databases):

Henrik
dbo
0
 
henrikatworkAuthor Commented:
This error actually occurs in the Visual Studio environment, I'm connected to the default database (myDatabase) with the user (Henrik) and the error is launched when I click the 'tables' - tab.
0
 
henrikatworkAuthor Commented:
I granted the select for Henrik and public, restarted the whole computer where the database runs + Visual studio.net on my computer, still it doesn't work :(
0
 
geotigerCommented:

Did you get the same error message? Is Henrik also a NT user? If not, then change your authentication to database only.
0
 
henrikatworkAuthor Commented:
I had to grant everything to public user to make it work, since Henrik isn't a NT user
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.