SQL Server 2005 Transactional Replication require configured between two different domain/two different SQL Server Services
-
Wednesday, January 02, 2013 8:17 AM
Try to setup the Replication between two different domain but OS level is same .i have facing the plenty of issue
Domain ENTIT domain NT Domain OS Level Window Server 2008 R2 Window Server 2008 R2 SQL Server Edition SQL Server Enterprise Edition with SP4 (9.00.5000.00) SQL Server Enterprise Edition with SP4 (9.00.5000.00) SQL Server Services/Agent Running ENTIT\sqladmincl0016 Local System Kindly guide me !!!!!!!
Rohit Gupta
All Replies
-
Wednesday, January 02, 2013 5:41 PMModerator
Use SQL authenication. If this does not work, use an account a local machine account on the publisher and create that account on the subscriber with the same password.
Then add these accounts to the db_owner role in the publication, distribution, and subscription databases.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
.png)
