Using SQL Server Application Roles from VB.NET Application

[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

[Cor Ligthert [MVP]]

Re: Using SQL Server Application Roles from VB.NET Application

Matt,

You told it yourself.

Probably the newsgroup

Microsoft.publi c.dotnet.framew ork.security
or
Microsoft.publi c.dotnet.securi ty

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


Cor

"Matt" <breakthrough@c ommunity.nospam > schreef in bericht
news:elMlkKJSGH A.4920@tk2msftn gp13.phx.gbl...[color=blue]
> 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[/color]