Can I add domain users to a database, when Sql Server A (the development server) is not part of the domain and has absolutely no access to the domain?
The domain users are of course not expected to work on server A, but these users are already configured on Sql Server B, the production sql server.
When a backup is taken on the development server A and deployed on the production server B, currently these users have to be re-added to the database on server B.
(The users do not have sysadmin rights on server B. As far as I know, if they had sysadmin rights, they would automatically have rights to access any new databases anyway)
Is it somehow possible to CREATE USER domain\xy
on development server A, so that they will work when restoring a backup on the production server B?
Or as a workaround, could I take a blank database backup with only the users from server B, and then use that backup as a base to create new databases on server A?