Browse by Tags

How to perform Replication within different domains?

Published 18 December 7 12:15 PM | SSQA.net

Got a question via email asking to configure Transactional Replication between two servers with in SQL Server 2005. By all means I would like to refer this KBA http://support.microsoft.com/kb/321822 for replication between HOW TO: Replicate Between Computers...

Filed under: sql server, security, replication, sa, transactional, impersonate, internet, different, domains

Property LoginSecure cannot be changed or read after a connection string has been set.

Published 24 August 7 3:55 AM | SSQA.net

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...

Filed under: sql server, security, replication, impersonate, distributor