<div>
The sa user might have been orphaned. Run the following command in the database.<br />
<br />
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).<br />

<pre><code id="code-7968224">exec sp_change_users_login 'auto_fix', 'sa'</code></pre>
</div>


The sa user might have been orphaned. Run the following command in the database.

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).


exec sp_change_users_login 'auto_fix', 'sa'

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
I am also doing transactional replication and I'm getting this error:<br />
<br />
Cannot execute as the database principal because the principal &quot;dbo&quot; does not exist, this type of principal cannot be impersonated, or you do not have permission. (Source: MSSQLServer, Error number: 15517)<br />
<br />
Anybody know a fix to this issue? <br />

</div>
</div>


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? 


DBO User ISSUE

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.