January 3, 2006 at 12:53 pm
Can I use approle from my ASP application if our SQL Server is configured as "Windows Authentication Mode" only?
If I want the user to connect to SQL Server using approle
what is my VB/ASP code? Do I have to provide "...User ID=xxx;password=xxx;"
in my connection string?
Rob
January 4, 2006 at 7:51 am
That's the confusing thing about application roles - they aren't use to connect to SQL Server. You first connect with some other valid login, then once connected, you activate the application role by executing the sp_setapprole stored procedure. Now, only the permissions assigned to the app role are active for the life of the connection.
You might want to read this: http://www.sqlservercentral.com/columnists/bkelley/sqlserversecurityprosandconsofapplicationroles.asp
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply