Data Access Peroperties' permissions grayed out

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
Fri Dec 05 08:50:02 CST 2003

Hi,

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

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com

"dw" <cougarmana_NOSPAM@uncw.edu> wrote in message
news:uoQQEvzuDHA.1760@TK2MSFTNGP10.phx.gbl...
> 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.
>
>

dw
Fri Dec 05 09:03:35 CST 2003

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" <miha at rthand com> wrote in message
news:OvnPR8zuDHA.3416@tk2msftngp13.phx.gbl...
> Hi,
>
> What credentials are you using for connection within VS.NET?
> Does it have enough privileges?
>
> --
> Miha Markic - RightHand .NET consulting & software development
> miha at rthand com
>
> "dw" <cougarmana_NOSPAM@uncw.edu> wrote in message
> news:uoQQEvzuDHA.1760@TK2MSFTNGP10.phx.gbl...
> > 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
Mon Dec 08 02:09:25 CST 2003

Hi,

"dw" <cougarmana_NOSPAM@uncw.edu> wrote in message
news:OTRQ2D0uDHA.1888@TK2MSFTNGP10.phx.gbl...
> 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?

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com

dw
Mon Dec 08 11:26:45 CST 2003

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

"Miha Markic" <miha at rthand com> wrote in message
news:OCcVYKWvDHA.1876@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> "dw" <cougarmana_NOSPAM@uncw.edu> wrote in message
> news:OTRQ2D0uDHA.1888@TK2MSFTNGP10.phx.gbl...
> > 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?
>
> --
> Miha Markic - RightHand .NET consulting & software development
> miha at rthand com
>
>