for some users, the connection in SSMS fails:
Cannot open user default database. Login failed.
Login failed for user ‘UserName’. (Microsoft SQL Server, Error: 4064)
why does not the connection like 'default' chosen? and this happens only for some users? why?
this user has permission to the database in question and that database has a proper owner. (no NULL)
when the user chooses a different database as default, then the connection goes through. but it is a pain to change everytime trying to connect SSMS.