Application Roles ENCRYPT function Valid Password Characters

From: Chuck Hawkins (charles.hawkins_at_NOSPAMjenzabar.net)
Date: 06/28/05 

Date: Tue, 28 Jun 2005 15:49:06 -0400

When I try to use the ODBC canonical ENCRYPT function for SP_SETAPPROLE, I
get an ODBC error when certain otherwise good characters are used in the
password. What characters are and are not allowed for passwords for
application roles while using the ENCRYPT function?

Relevant Pages

  • Re: Application Roles ENCRYPT function Valid Password Characters
    ... > When I try to use the ODBC canonical ENCRYPT function for SP_SETAPPROLE, ... > get an ODBC error when certain otherwise good characters are used in the ...
    (microsoft.public.sqlserver.security)
  • Re: Application Roles ENCRYPT function Valid Password Characters
    ... The password characters are not allowed for or the canonical ENCRYPT function does not work with characters with the following ASCII codes: ... what are valid password characters for application roles in order for the ENCRYPT function to work? ... > remove references to the unallowed characters mentioned in Security Rules ...
    (microsoft.public.sqlserver.security)
  • Re: Application Roles ENCRYPT function Valid Password Characters
    ... remove references to the unallowed characters mentioned in Security Rules ... I'm still having the problem with the ENCRYPT function. ... switch the TEST app role over to a password of 'easy', ...
    (microsoft.public.sqlserver.security)