Re: Naming convention for Login names?

Normally, valid names should contain only letters and numbers, starting with
a letter.

The inclusion of '\' with your TestUser name is what caused it to be
invalid.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"ANeelima" <neelima@xxxxxxxxxxxxxxxxx> wrote in message
news:EBA5FA3C-6B21-4304-8943-81C8928086D3@xxxxxxxxxxxxxxxx
I have a VB 6.0 application using SQL DMO that adds user Logins to SQL
Server
2005 Express programmatically.

I would like to validate
the logins before they get added. I was wondering what the naming
conventions
are?

For example, If I use 'TestUser\' as login name, I get the following error
from Microsoft.SQLServer.Express.SMO

"TestUser\ is not a valid name because it contains invalid characters".

How would one know ahead of time whether the login contains invalid
characters or not? What sort of characters should I be testing the name
against?
--
ANeelima


.

Relevant Pages

  • Re: how does excel decide a suggested name to a range?
    ... > characters that are invalid in a name, ... for example) are also invalid. ... I remove all characters other than letters and numbers and ... > then use underscore between the two tokens to get something like ...
    (microsoft.public.excel.programming)
  • Re: Is alpha Numeric
    ... characters, ... > How can I tell if a field on a form contains an Alpha ... I want to make sure the field contains both, numbers and letters. ...
    (microsoft.public.access.formscoding)
  • Re: Is alpha Numeric
    ... > ' invalid ... > characters, then add a third test: ... I want to make sure the field contains both, numbers and letters. ...
    (microsoft.public.access.formscoding)
  • Re: who wants a crack at this
    ... (and IIRC my Javascript) all ... > non-alphabetic characters are effectively converted to 'A'. ... I posted a while back that Login 4.2 had a complete break. ... much faster if a short password under 10 letters is used. ...
    (sci.crypt)
  • Re: User Accounts
    ... Change the name of the account. ... hackers as a means of getting a foothold into your system. ... using all upper case or all lower case letters. ... It should contain at least eight characters. ...
    (microsoft.public.windowsxp.help_and_support)
Quantcast