azure sqldw - LOGINs on new MASTER for restored database -
i have new logical server on restoring existing azure sql data warehouse database different logical server.
i've reviewed https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-restore-database-portal need understand how logins handled on new master database. users exist on database restored , relate logins on old master database.
do logins have manually created on new master before restore occurs?
the logins have created on master of new logical server. can happen anytime before re-create users in dw. after have logins created, need drop , re-create users in dw restored new logical server. associate users in dw logins in master.
if have aad integration on-premises ad in place , enabled dw, these steps not needed.
Comments
Post a Comment