I'm trying to switch servers, so I need to recreate my databases, but I cannot seem to recreate the logins for SQL Server the same as my old server. Here is what one of them looks like:
Note the user and default schema. If I check the box next to SmarterTrack on my new server, the user turns into STAdmin automatically, which is the name of the login I'm trying to create. So, I click on STAdmin and change it to dbo, then default schema to dbo, but when I click ok to save the new login, it says dbo user already exists. How do I set this up? There must be a way since it's like this on my old server.