Data Access Peroperties' permissions grayed out

[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.

 

[Miha Markic]

Hi,

What credentials are you using for connection within VS.NET?
Does it have enough privileges?

 

[dw]

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.

 

[Miha Markic]

Hi,

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.

Yep, you understood correctly.
If you connect via Enterprise Manager does it let you modify database?

 

[dw]

Yes, it does. I can create/modify/delete stored procedures/tables, etc. But
that's only via Enterprise Manager.