Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2005-05-10
9
Medium Priority
?
326 Views
Last Modified: 2012-06-22
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
0
Comment
Question by:henrikatwork
  • 5
  • 4
9 Comments
 
LVL 12

Expert Comment

by:geotiger
ID: 13967457

You need to do both:

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


GT
0
 
LVL 1

Author Comment

by:henrikatwork
ID: 13967644
I already did that, I've given the user full access to both the master database and myDatabase. Any ideas?

0
 
LVL 12

Expert Comment

by:geotiger
ID: 13967687

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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:henrikatwork
ID: 13967955
Dbowner (for all databases):

Henrik
dbo
0
 
LVL 1

Author Comment

by:henrikatwork
ID: 13967973
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
 
LVL 12

Accepted Solution

by:
geotiger earned 2000 total points
ID: 13968053

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
 
LVL 1

Author Comment

by:henrikatwork
ID: 13969758
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
 
LVL 12

Expert Comment

by:geotiger
ID: 13985215

Did you get the same error message? Is Henrik also a NT user? If not, then change your authentication to database only.
0
 
LVL 1

Author Comment

by:henrikatwork
ID: 13992760
I had to grant everything to public user to make it work, since Henrik isn't a NT user
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question