user login problem

Question

dear admins
I create a new user login for a database with this option:
General:
{
login name : abcd
password:1234
default database: master
}
Server role : public
User Mapping:
{
Database: advantureWork
role memberShip: public
}
then OK;
this user added to two databases;
I checked again and again, I'm sure that I select one database in user mapping option;
i don't what happend! do you know?

Answer 1

this user added to two databases;

Guess into the blue: An orphaned database user with same user name, but different SID. Can you access the database using the login?

https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/troubleshoot-orphaned-users-sql-server?view=sql-server-ver15

Answer 2

Hi @john doe ,

Just like Olaf said, whether you can access both two databases using this login?
Or you can just use T-SQL to create a login user

USE [master]  
GO  
CREATE LOGIN [abcd] WITH PASSWORD=N'1234', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF  
GO  
USE [advantureWork]  
GO  
create USER [abcd] FOR LOGIN [abcd]  
GO