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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

geotigerCommented:

You need to do both:

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


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

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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

henrikatworkAuthor Commented:
Dbowner (for all databases):

Henrik
dbo
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.
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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 :(
geotigerCommented:

Did you get the same error message? Is Henrik also a NT user? If not, then change your authentication to database only.
henrikatworkAuthor Commented:
I had to grant everything to public user to make it work, since Henrik isn't a NT user
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.