Using SQL Server Application Roles from VB.NET Application

16 Mar 2006 12:43 AM

Matt

I'm not entirely sure if this is the best place to post this; if it is
not, kindly redirect me to the proper posting area.

I'm deploying a Windows Forms application using VB 2005 on top of SQL
Server 2005, and I was trying to figure out the best possible way to
secure the system such that only the users using the application would
be able to access the database. I stumbled across the concept of
Application Roles in SQL Server, but none of the explanations floating
around online properly demonstrate how one would actually go about using
them. Can anyone refer me to a good source on this matter, or give me a
better solution for security altogether?

Thanks,
Matt

16 Mar 2006 6:11 AM

Cor Ligthert [MVP]

Matt,

You told it yourself.

Probably the newsgroup

Microsoft.public.dotnet.framework.security
or
Microsoft.public.dotnet.security

are in my opinion the best places for that complete message from you.

Cor

Show quoteHide quote

"Matt" <breakthrough@community.nospam> schreef in bericht
news:elMlkKJSGHA.4920@tk2msftngp13.phx.gbl...
> I'm not entirely sure if this is the best place to post this; if it is
> not, kindly redirect me to the proper posting area.
>
> I'm deploying a Windows Forms application using VB 2005 on top of SQL
> Server 2005, and I was trying to figure out the best possible way to
> secure the system such that only the users using the application would be
> able to access the database. I stumbled across the concept of Application
> Roles in SQL Server, but none of the explanations floating around online
> properly demonstrate how one would actually go about using them. Can
> anyone refer me to a good source on this matter, or give me a better
> solution for security altogether?
>
> Thanks,
> Matt