I've been setting users for SQL servers for a year and this is the first time happened to me.
I am trying to set a new login/password/user with SQL server authentication on a new server.
I set up a fresh test database, new login and user for that database. I don't get any error, just confirmation that user was created OK.
After I disconnect and try to connect again to the SQL Server with the SQL server authentication using this user/password, I get an error that user is not associated with the trusted SQL server connection. User name and password are correct.
I do the same thing on an old server and everything works fine.
I checked Surface Area configuration, remote connections are set to allow local and remote connections.
What can be the reason that SQL server users do not work?