开发者

Change subscriber connection on SQL Server Replication Subscription through .net

I've got a block of .net code which creates replication subscriptions between two SQL Server 2008 instances. Mostly it works fine, but whenever it's run it sets the "subscriber connection" property to "Impersonate Windows Account". This works locally but it isn't what we need in the live environment at all - it needs to be a SQL server logon. However I can't find the correct propert/method/syntax (or anything really) in the SqlServer.Replication.TransSubscription class to change it.

Can anyone point me in the right direc开发者_如何学运维tion? Am I even looking in the correct class to control this programatically?

Cheers, Matt


It's a bit hard to tell without seeing any code, but is the ConnectionSecurityContext what you need to change this setting?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜