Welcome to SSQA.net Sign in | Join | Help

SQL Server Replication (SSQA.net)

Another methodology to distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.
Property LoginSecure cannot be changed or read after a connection string has been set.

I was stumped on the above error when configuring distributor afresh using SSMS.

Eventually found that this is due to impersonate settings that were not setup, so to resolve this simply:

  • Right click local publicaiton->Distributor properties
  • Select the publisher in the list, click ...
  • In agent connection mode, select "impersonate the agent process account"
Posted: Friday, August 24, 2007 1:55 AM by SQL Master

Comments

Other SQL Server Blogs around the Web said:

I was stumped on the above error when configuring distributor afresh using SSMS. Eventually found that

# August 24, 2007 2:28 AM

SSQA.net - SqlServer-QA.net said:

I was stumped on the above error when configuring distributor afresh using SSMS. Eventually found that

# August 24, 2007 2:42 AM
Anonymous comments are disabled