A question about creating SQL Server login

by 22878   Last Updated October 10, 2019 03:06 AM - source

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:

login

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.



Related Questions




How to enable a user using a script?

Updated November 22, 2018 11:06 AM