Re: Special characters on passwords
From: James Hokes (nospam_nothanks__at_nospamforme_nothanks.com)
Date: 03/01/04
- Next message: Robert.Alexander: "64 bit Performance Just not there!!"
- Previous message: Sebastian K. Zaklada: "Re: Special characters on passwords"
- In reply to: Reydeval Rocha: "Special characters on passwords"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 1 Mar 2004 15:29:22 -0500
Reydeval,
For some bizarre reason, Query Analyzer uses ODBC for its connections.
I would suspect that the embedded semicolon is wreaking havoc with the
internally-generated Connection String.
I tried the following (a standard ODBC workaround):
wrap the password in curly braces { }
It's a pain in the arse, but I tried it and it worked with Query Analyzer
and an embedded semicolon.
James Hokes
"Reydeval Rocha" <anonymous@discussions.microsoft.com> wrote in message
news:4d3201c3ffc6$f0928ed0$a401280a@phx.gbl...
Hi,
I am having some problems with passwords including special
characters like ';' on SQLServer. I can change an userīs
password to ';', by Enterprise Manager, but the user canīt
log on Query Analyzer. The SQLServer shows a
message: "Login failed for user:...". I saw on BOL that we
can use any character including numbers, letters or
simbols to be a password. Anybody knows a list of
characters that I canīt use on passwords?
Thanks,
- Next message: Robert.Alexander: "64 bit Performance Just not there!!"
- Previous message: Sebastian K. Zaklada: "Re: Special characters on passwords"
- In reply to: Reydeval Rocha: "Special characters on passwords"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
