Thank you very much for clarifying. But I didn't even know you can create a database user before the server login. So I always create server login first and then user in the database.
>If you created the database login before the server login, you can't just create the server login. You need to delete the user created in the database, then create the user in the server.
>
>>I think you are maybe on to something. I created this database on my SQL Server and then attached it to the customer SQL Server. What I don't understand is I never created a user in my SQL Server. Do I am trying to figure out what you mean by "delete first the login at the database". How do I find out if this login exist? Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham