faclogistics
asked on
DBO User ISSUE
I've attached a database from one server to another and the dbo user is still located at the database level but i'm unable to give the sa user access to the database because it was already located at the db level.
I am also doing transactional replication and I'm getting this error:
Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission. (Source: MSSQLServer, Error number: 15517)
Anybody know a fix to this issue?
I am also doing transactional replication and I'm getting this error:
Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission. (Source: MSSQLServer, Error number: 15517)
Anybody know a fix to this issue?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Another option is to drop the sa user from the restored database and map it again (this will lose any explicit permissions assigned in that database).
Open in new window