I am trying to setup a new server with databases that exist on an old server. My plan is to create a blank database and restore the backup database to the new server.
I have created the database and pointed the data/log files to the appropriate locations. I created a user and assigned it ownership to the database. After the restore, the user exists in the database, but the user in the security section does not have permission. if i try to add the user it get the error above.
Am i missing something?