Wednesday, December 18, 2013

TransSubscription.SubscriberSecurity will not update!

Problem
I noticed that I forgot to set the SubscriberSecurity to use SQL Authentication. This popped up as a "Could not login to the subscriber" type of error in the Replication Monitor. So i thought, ok, this should be simple, just update the SubscriberSecurity.UseWindowsAuthentication = false, then specify the username and password. According to this article that should work: http://technet.microsoft.com/en-us/library/ms151761.aspx#RMOProcedure

Solution
The documentation is missing the fact that you have to call SubscriberSecurity.Update() after setting the values. In fact, the documentation on "Update()" makes little to no sense. It says "Updates the schedule fields for the connection object". What are the schedule fields? I don't know, but calling Update() finally pushed the changes through.

No comments:

Post a Comment

There was an error in this gadget