For DBA its a routine activity to change server passwords.
If we are using replication between servers and if we are changing password of subscribers
we have to change it on publisher also.
we can use sp_changesubscription here to change password for the subscriber.
We can use it for changes the properties of a snapshot or transactional push subscription or a pull subscription involved in queued updating transactional replication
We have to run this on publication database
Also it support many other properties for subscribers which we can change.
for other replication we have to use sp_change_subscription_properties (Transact-SQL).
This also support changes of password like
distrib_job_password,distributor_password,dts_package_password ,ftp_password ,internet_password,merge_job_password
Look at BOL for more detail information .
If we are using replication between servers and if we are changing password of subscribers
we have to change it on publisher also.
we can use sp_changesubscription here to change password for the subscriber.
We can use it for changes the properties of a snapshot or transactional push subscription or a pull subscription involved in queued updating transactional replication
We have to run this on publication database
EXEC Sp_changesubscription
@publication ='test',
@article = 'all',-- here password change will affect all articles
@destination_db =
'dest-test',
@subscriber =
'REPORTSERVER',
@property =
'subscriber_password',
@value = 'abc123'
Also it support many other properties for subscribers which we can change.
for other replication we have to use sp_change_subscription_properties (Transact-SQL).
This also support changes of password like
distrib_job_password,distributor_password,dts_package_password ,ftp_password ,internet_password,merge_job_password
Look at BOL for more detail information .
2 comments:
Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work.
jiofi local html
Hello there, I must confess that I have browsed many of your posts. And this particular post is probably where I got the most useful stuff for my research. Thanks for posting this amazing piece, hope we can see more on this. Are you aware of any other websites on this subject? JioFiLocalHtml
Post a Comment