更改订阅属性时发生错误 [英] Error occurred while changing subscrption properties

问题描述

我对发布中的表之一进行了更改，并运行了快照，在订阅者端，我尝试使用订阅属性并给定正确的用户名和密码，更改为sql服务器身份验证(在连接到发布之前是基本身份验证)我单击确定"按钮，它将显示以下错误消息

值大于128，不应超过.
参数名称:值(Microsoft.sqlserver.rmo)

尝试还原所做的更改也会显示相同的错误.

您能否让我知道如何解决此问题.

谢谢，

Vasanth

Hi,

I made changes to one of the table in the publication and run the snapshot, at subscriber end i have tried to change into sql server authentication(which was Basic authentication while connecting to publication before)using subscription properties and given correct username and password but when i click on "OK" button, it will display below error message

Value is longer than 128 that it should not exceed.
Parameter name: value (Microsoft.sqlserver.rmo)

tried to revert back the changes also will display same error.

Could you please let me know how to solve this problem.

Thanks,

Vasanth

推荐答案

我找到了解决上述错误的方法.

我试图输入用户名"和密码"，而没有完全删除现有值.

因此，在添加/修改任何用户名和密码之前，我们必须完全删除现有的登录凭据.

就我而言，这解决了问题.

谢谢，

Vasanth

Hi,

I found the solution for the above error.

i was trying to enter "username" and "Password" without removing the existing value completely.

So, Before add/modify any username and password we have to remove existing login credentials completely.

In my case this solved the problem.

Thanks,

Vasanth

这篇关于更改订阅属性时发生错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！