Re: Application Roles ENCRYPT function Valid Password Characters

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

Date: Wed, 29 Jun 2005 08:04:15 -0400

Thank you, Sue. I went back and re-wrote my password generation script to
remove references to the unallowed characters mentioned in Security Rules
for passwords - []{}(),;?*! @.
I'm still having the problem with the ENCRYPT function. I execute:

sp_setapprole
@rolename = 'TEST',
@password = {Encrypt N
'ro11ùª¨¿®1гPÍñMï0ciï±ÄµTºÕx¡÷àmïÎOKìÆÆe3qJ³ÒÎíDî²tSÝàVçÞ«½îX£¦rиô"SÕ׬?Dãøk2Õ»q6×ðLÛ¹µÀE¬vrv×I1¸m¿èOñEâNycWÓpLvzãjáöLâ²Ç?Ï3kïn'}
--@password = {Encrypt N 'easy'}
,@encrypt = 'odbc'
go

And get:
[Microsoft][ODBC SQL Server Driver]Syntax error or access violation

I know I don't have a syntax error (other than an ugly password). When I
switch the TEST app role over to a password of 'easy', it works.

Am I supposed to put braces [] around the password somehow?

So the question remains, what characters are not allowed for passwords? I
know []{}(),;?*! @. are not, but I don't have any of these.

Chuck

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:99a4c1p6996f5mklnjbq0hhmapjunkv95u@4ax.com...
> You can find the valid characters in the books online help
> topic: Security Rules.
> You can find the topic in the index under passwords, rules
> for
>
> -Sue
>
> On Tue, 28 Jun 2005 15:49:06 -0400, "Chuck Hawkins"
> <charles.hawkins@NOSPAMjenzabar.net> wrote:
>
>>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
    ... 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
    ... You can find the valid characters in the books online help ... topic: Security Rules. ... You can find the topic in the index under passwords, ...
    (microsoft.public.sqlserver.security)
  • 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)