Data Access Peroperties' permissions grayed out

  • Thread starter Thread starter dw
  • Start date Start date
D

dw

I've tried to connect to SQL Server via VS.NET -- and I'm the dbo -- but the
permissions area of the Data Access Properties area is grayed out. It only
lets me view the objects, not edit/create in Server Browser. Any help is
appreciated. Thanks.
 
Hi,

What credentials are you using for connection within VS.NET?
Does it have enough privileges?
 
Thanks, Miha. If I understand your question correctly, I'm using NT
integrated security to connect to the db. How can I check to see if it has
enough privileges? If I'm the dbo, wouldn't that give me all the necessary
privileges? Thanks.
 
Hi,

dw said:
Thanks, Miha. If I understand your question correctly, I'm using NT
integrated security to connect to the db. How can I check to see if it has
enough privileges? If I'm the dbo, wouldn't that give me all the necessary
privileges? Thanks.
Click to expand...

Yep, you understood correctly.
If you connect via Enterprise Manager does it let you modify database?
 
Yes, it does. I can create/modify/delete stored procedures/tables, etc. But
that's only via Enterprise Manager.
 
Back
Top