Home > Ask the SQL Server Experts > Michael Hotek Questions & Answers > Error setting up replication across network domains
Ask The SQL Server Expert: Questions & Answers
EMAIL THIS

Error setting up replication across network domains

Michael Hotek EXPERT RESPONSE FROM: Michael Hotek

Pose a Question
Other SQL Server Categories
Meet all SQL Server Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 19 April 2004
I am trying to set up merge replication between two servers-- one publisher/distributor and another pull subscriber across network domains. I am encountering several errors when after setting up the pull subscription and it tries to initally run. I was not able to sucessfully set up an anonymous or impersonated environment, but was able to connect to the publisher and distributor using a SQL Server Authenticated account. But then I get "can not be propagated to subscriber" error along with "OS error 1909" and then "The referenced account is currently locked and may not be logged into". Can it be that merge replication across domains is not recommended or allowed? I did not have these problems when working on the same domain. Any suggestions?

>

Don't have any specific suggestions for fixing it. The error you are getting is precisely correct. If you go to the Windows account, you will in fact find that it has been locked out due to repeated login failures. I've encountered this one before within a single domain. The fix was entirely on the Windows side, but I do not remember how it was fixed. It seemed that the replication engine made several attempts to login which failed for some reason causing the security mechanisms in Windows to kick in and lock out the account. You do need to make sure that the account which replication is running under, generally the SQL Agent account, has access to the machines in both domains.

For More Information


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
Michael Hotek
Applying LDF file to MDF without turning it to .BAK first?
Procedure for finding last modified info?
Migrating poorly designed database to new, normalized one
Displaying decimal places in SQL Server 2000
Creating a DTS package
Extracting data without strings converted to strange characters
Money data type conversion issue using DTS
Any way to alias a call to functions?
Repairing corrupt MDF files
In-place versus side-by-side upgrade

SQL Server Replication
SQL Server Mailbag: Migrating down to Standard Edition
Push vs. pull: Configuring SQL Server replication
Top load balancing methods for SQL Server
New replication features in SQL Server 2008 and what they mean to you
SQL Server database replication tutorial
Licensing a standby server for SQL Server replication
Upgrade live applications to SQL Server 2005 for high availability
Tool to synchronize two SQL Server databases
Simplify SQL Server replication
Replication techniques in SQL Server

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
replication  (SearchSQLServer.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



SQL Solutions - SQL Database Design
HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts