Stephen,

>I posted my code a while ago but I haven't got a respond. I need to know if I should spend more time on this or I should just go find another way to do what I want. Let me know if you need more information.
>
>BTW, I wrote a VERY simple MM.NET application with the application role but I got the same result.

Sorry it took me so long to get back to you...we were out of power for three full days due to hurricane Isabel, and then I went on the road for a few days!

Anyway, at the point where you have this code:

public void ExecuteSQLSetAppRole()
{
      this.ExecNonQuery("EXEC sp_SetAppRole 'AAValidatedUser','xxx'");
}

Does it work properly if you replace this code with straight ADO.NET code?

Regards,