Hey friends, I am filling good to write my 1st post in 2015. This is related to error in replication which i faced in 2014 he he.
Last month i was facing an error during roll backing Transnational replication as below..
------------------------------
Could not delete publication 'XXX'. Microsoft SQL Server, Error: 15517
TITLE: Microsoft.SqlServer.ConnectionInfo
------------------------------
SQL Server could not disable publishing and distribution on 'SUMAN-29'.
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)
Last month i was facing an error during roll backing Transnational replication as below..
------------------------------
Could not delete publication 'XXX'. Microsoft SQL Server, Error: 15517
TITLE: Microsoft.SqlServer.ConnectionInfo
------------------------------
SQL Server could not disable publishing and distribution on 'SUMAN-29'.
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)
I resolved through below :-
1st run below query in SSMS.
ALTER AUTHORIZATION ON DATABASE::[DBNAME] TO [sa]
2nd Then Right click On publication and choose delete
3rd Then disable the distributor..
Now just refresh instance
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757