Delete Publication: “the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission”

Problem:

I have installed a local Publication.

For whatever reason I need to delete it from this server.

I tried with right-click Delete and with Disable Publishing and Distribution.  The same result:

“TITLE: Microsoft.SqlServer.ConnectionInfo

SQL Server could not disable publishing and distribution on <computer-name>\<sqlServerName>.

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

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.

Changed database context to ‘master’. (Microsoft SQL Server, Error: 15517)”

Solution:

the database didn’t have an owner so when i logged in (as any account) I was not able to alter the owner using a query. So I logged in as SA right clicked the database ->properties->files->…(2nd setting) and assigned the owner to SA. Now its sorted!

 

Reff:

http://social.msdn.microsoft.com/Forums/lv/sqlreplication/thread/a4a6361a-01b0-4ed5-b624-94073c5930b1

Advertisements
By simplemsexchange Posted in SQL 2008

One comment on “Delete Publication: “the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission”

  1. Thanks,worked for me. This is a great solution of for follwoing problem:
    the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s