Disabling Distributor & Publishing Error

Question

Post reply

Disabling Distributor & Publishing Error

shohelr2003

Hall of Fame

Points: 3535
More actions
November 7, 2012 at 11:42 pm

#264493

Dear,
I am trying to disable my distributor and publisher in replication but I am getting the following error message.
[
TITLE: Microsoft.SqlServer.ConnectionInfo
------------------------------
SQL Server could not disable publishing and distribution on 'SERVER1'.
------------------------------
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)
]
please help me to sort out the problem.
Regards,
Akbar

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

sanket kokane Hall of Fame Points: 3465 More actions · Answer 1

please check if there any db_owner for your database used in replication.

if there is no change it to SA or any other active login

use Yourdatabase

go

sp_changedbowner 'sa'

-----------------------------------------------------------------------------
संकेत कोकणे

shohelr2003 Hall of Fame Points: 3535 More actions · Answer 2

sanket kokane (11/7/2012)
please check if there any db_owner for your database used in replication.
if there is no change it to SA or any other active login
use Yourdatabase
go
sp_changedbowner 'sa'

pls can u tell me the meaning of this line "Changed database context to 'master'. (Microsoft SQL Server, Error: 15517)"

sanket kokane Hall of Fame Points: 3465 More actions · Answer 3

pls can u tell me the meaning of this line "Changed database context to 'master'. (Microsoft SQL Server, Error: 15517)"

Hi thats just a informational message ..

I think link below will help you more

http://support.microsoft.com/kb/913423/en-us

-----------------------------------------------------------------------------
संकेत कोकणे

shohelr2003 Hall of Fame Points: 3535 More actions · Answer 4

Hi thats just a informational message ..
I think link below will help you more
http://support.microsoft.com/kb/913423/en-us

I have gone through the above link. But I am using SQL Server 2008 R2. Will it work?

Thank You.

sanket kokane Hall of Fame Points: 3465 More actions · Answer 5

its working fine for me in SQL serevr 2008 R2

or else another option is

ALTER AUTHORIZATION ON DATABASE::YourDatabaseName TO sa

GO

-----------------------------------------------------------------------------
संकेत कोकणे

shohelr2003 Hall of Fame Points: 3535 More actions · Answer 6

shohelr2003

Hall of Fame

Points: 3535

November 8, 2012 at 4:05 am

#1557087

Thank you, SSC Veteran for your co-operation.