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.
我有一个.net代码块，它在两个SQL Server 2008实例之间创建复制订阅。它通常工作得很好，但是无论何时运行，它都会将“订阅服务器连接”属性设置为“模拟Windows帐户”。这在本地工作，但它根本不是我们在活动环境中需要的——它需要一个SQL服务器登录。但是，我在SqlServer.Replication中找不到正确的属性/方法/语法(或者其他东西)。订阅类以更改它。
Can anyone point me in the right direction? Am I even looking in the correct class to control this programatically?
有人能告诉我正确的方向吗?我是否正在寻找正确的类来控制这个程序?
Cheers, Matt
欢呼,马特
1 个解决方案
#1
1
It's a bit hard to tell without seeing any code, but is the ConnectionSecurityContext what you need to change this setting?
在没有看到任何代码的情况下很难判断，但是ConnectionSecurityContext需要更改这个设置吗?
#1
1
It's a bit hard to tell without seeing any code, but is the ConnectionSecurityContext what you need to change this setting?
在没有看到任何代码的情况下很难判断，但是ConnectionSecurityContext需要更改这个设置吗?