How can I set the login name in sql server 2005?

AndreasD

Hi,
after I import a Navision 5.01 database the logins in that specific database only have a user name but no login name. But the verification of user name and password is obviously done only for the login name and not the user name.
So I have to set the login name the same as the user name.
Unfortunately the text field for the login name in newly imported databases is greyed out (not active).
So I have to delete the user in the database and add the user again this time with user name and login name (the same as the user name). For every user.
All the necessary users are already in the database and I have to do this procedure just because they are lacking the login name.
How can I fix it in a better way than deleting and adding the user again in MS SQL Server 2005?
How can I prevent this the next time?
Is there a stored procedure for this?
Thank you.
Sincerely
Andreas

kine

May be I just do not understand what you mean with the user name and what with the login name.

Are you talking about windows logins or DB logins?