當(dāng)你從現(xiàn)有的bak文件，恢復(fù)數(shù)據(jù)庫時(shí)，如果數(shù)據(jù)庫本身帶有一個(gè)用戶：比如用戶叫：DemoUser.你無法創(chuàng)建一個(gè)相同的用戶并mapping這個(gè)用戶到數(shù)據(jù)庫， 并且你無法刪除數(shù)據(jù)庫的用戶：DemoUser，下文將為您講解如何解決這個(gè)問題。
下文為您講解恢復(fù)sql server 數(shù)據(jù)庫時(shí)，無法刪除原始數(shù)據(jù)庫用戶的方法，供您參考，希望對您有所幫助。
當(dāng)你從現(xiàn)有的bak文件，恢復(fù)數(shù)據(jù)庫時(shí)，如果數(shù)據(jù)庫本身帶有一個(gè)用戶：比如用戶叫：DemoUser.你無法創(chuàng)建一個(gè)相同的用戶并mapping這個(gè)用戶到數(shù)據(jù)庫， 并且你無法刪除數(shù)據(jù)庫的用戶：DemoUser.
請運(yùn)行以下腳本， 之后你就可以刪除用戶：DemoUser.然后創(chuàng)建用戶（DemoUser.）并mapping到數(shù)據(jù)庫。
腳本：
view source
ALTER AUTHORIZATION ON ROLE::[aspnet_Membership_BasicAccess] TO [dbo] |
ALTER AUTHORIZATION ON ROLE::[aspnet_Membership_FullAccess] TO [dbo] |
ALTER AUTHORIZATION ON ROLE::[aspnet_Membership_ReportingAccess] TO [dbo] |
ALTER AUTHORIZATION ON ROLE::[aspnet_Profile_BasicAccess] TO [dbo] |
ALTER AUTHORIZATION ON ROLE::[aspnet_Profile_FullAccess] TO [dbo] |
ALTER AUTHORIZATION ON ROLE::[aspnet_Profile_ReportingAccess] TO [dbo] |
ALTER AUTHORIZATION ON ROLE::[aspnet_Roles_BasicAccess] TO [dbo] |
ALTER AUTHORIZATION ON ROLE::[aspnet_Roles_FullAccess] TO [dbo] |
ALTER AUTHORIZATION ON ROLE::[aspnet_Roles_ReportingAccess] TO [dbo] |
ALTER AUTHORIZATION ON SCHEMA::[db_owner] TO [dbo] |
ALTER AUTHORIZATION ON SCHEMA::[db_owner] TO [db_owner] |
