How I use an Applicaton Role?

[aecordoba]

Hi folks! I'm coding a very simple Windows Application on VS 2005 (C#) in order to see the records of Customers table of Northwind database. This Windows Application works fine by "Debugging" on VS 2005 enviroment with "Windows Authentication" to connect to the database. Now, I thinking to deploy the application, so I created an "Application Role" in the Northwind database. But, how do I use that Application Role in my application? How do I invoke it? Can somebody help me? (Details and reference to step by step guides will be appreciated.)

-- Adrián Córdoba

[KaptinKrunch]

I'm waiting for the day google does not have the answer. http://msdn2.microsoft.com/en-us/library/5k850zwb.aspx[^]

Just because we can; does not mean we should.

[aecordoba]

KaptinKrunch wrote:

I'm waiting for the day google does not have the answer. http://msdn2.microsoft.com/en-us/library/5k850zwb.aspx\[^\]

KaptinKrunch: I'm talking about to use "Application Roles" (from MS SQL Server's roles) in my application for connecting to the database. I'm not talking about roles for my applicaton. In other words, how do I modify my application (now using Windows Authentication) to connect to the database by using an application role that I created in the database (SQL Server Management Studio)? I saw several sites found by mean Google, but I didn't find a good guide for this purpose. Anyway, thank you for your answer.

-- Adrián Córdoba