Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Disabling Distributor & Publishing Error Expand / Collapse
Author
Message
Posted Wednesday, November 7, 2012 11:42 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 3, 2014 4:04 AM
Points: 203, Visits: 500
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
Post #1382273
Posted Wednesday, November 7, 2012 11:49 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 1, 2013 10:17 AM
Points: 323, Visits: 984
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'




-----------------------------------------------------------------------------
संकेत कोकणे
Post #1382276
Posted Thursday, November 8, 2012 12:19 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 3, 2014 4:04 AM
Points: 203, Visits: 500
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)"
Post #1382291
Posted Thursday, November 8, 2012 12:47 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 1, 2013 10:17 AM
Points: 323, Visits: 984
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


-----------------------------------------------------------------------------
संकेत कोकणे
Post #1382299
Posted Thursday, November 8, 2012 1:57 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 3, 2014 4:04 AM
Points: 203, Visits: 500


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.
Post #1382328
Posted Thursday, November 8, 2012 3:30 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 1, 2013 10:17 AM
Points: 323, Visits: 984
its working fine for me in SQL serevr 2008 R2

or else another option is

ALTER AUTHORIZATION ON DATABASE::YourDatabaseName TO sa
GO



-----------------------------------------------------------------------------
संकेत कोकणे
Post #1382368
Posted Thursday, November 8, 2012 4:05 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 3, 2014 4:04 AM
Points: 203, Visits: 500
Thank you, SSC Veteran for your co-operation.
Post #1382384
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse