July 20, 2005 at 9:25 am
I have never used applicationroles before, so now I am trying to get one working. I have followed a step-by-step process and got stukc. So what do I do wrong?
I have create AplRolTest for Pubs, gave the role permission to read all usertables. Now I am trying to make an ODBC-connection from my pc, using AplRoleTest as login with the correct password, but receive the message LOGIN FAILED FOR USER APLROLETEST. I have used QA to execute SP_SETAPPROLE and set this role active. This specific server has mixed security: both windows as security logins are allowed.
If I create an ordinary SQL useraccount I can login without a problem.
What am I missing here? It must be something simple, I'm sure, but I can't think of what to check.
Greetz,
Hans Brouwer
July 20, 2005 at 10:50 am
To use an application role, first login with a normal login. This can be SQL Server or Windows based, but it must have access to the SQL Server. The application role itself is not a valid login.
Change to the database where the appliction role is found (that means the login must have been granted access to the database). Then execute the sp_setapprole. That will trigger the application role.
K. Brian Kelley
@kbriankelley
July 21, 2005 at 5:29 am
Got it going, tnx.
Greetz,
Hans Brouwer
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply