ron

Will having a period in a login name create a invalid
character error when adding name to database?

Example; previous login names that worked - navsea_jonesrb

name that will not work - navsea_ronald.jones

vishal parkar

Ron,

Im not very sure about the compatibility of SQL 6.5 but in SQL 2000 you can create the
same login name by enclosing single quote around the login name. Following works in SQL
2000

sp_addlogin 'navsea_jonesrb.jones'

-- However following will fail.

sp_addlogin navsea_jonesrb.jones

Try putting single quotes around the login name and subsequently in sp_adduser.
--
-Vishal