August 24, 2001 at 2:09 pm
Hello,
I am trying to do a merge replication from a sql server on the local domain to one that is not on a domain. But every time I try to do a subscription pull, I recieve authentication errors from the sql server on the domain even though they are set up correctly in terms of login authentication. I tried doing a push from the computer on the domain to the one that is not and recieved the tables in the non domain sql server but no data (even though the distributing computer claimed that the data had been sent to the non domain computer with no errors). Is there any way I can do the subscription without having the non domain computer put onto the domain? Both computers use NT operating systems.
August 24, 2001 at 9:33 pm
I dont think being a domain member is a requirement, it just makes authenticating easier. If you're not a domain member you'll have to use either a SQL login and/or anonymous FTP. First priority is to establish connectivity - preferably using a VPN. One you can connect and prove you're connected, then move to getting replication to work.
Andy
August 27, 2001 at 1:50 pm
None of that is necessary and won't fix or solve the problem.
Create a local account on each machine that has the same name and password. Make this account a member of local admins. Set the SQL Server and SQL Agent services to use this account.
You are now done and ALL authentication issues will be gone for replication.
Mike
SQL Server MVP
Mike
SQL Server MVP
http://www.mssqlserver.com
August 28, 2001 at 1:08 pm
Hey Mike,
What if I want to use a domain account for sql and/or the agent? This is kinda nice to have in my opinion. Do you think using SQL login/password for distribution is too much work, or have you found a flaw, or just the other method you recommended is less work overall?
Andy
August 28, 2001 at 1:13 pm
You can use a domain account. You just have to deal with multi-domain trust issues and all the rest of those problems which you can't normally control. It doesn't matter if you mix domain nad non-domain accounts as long as the user name and password are exactly the same, you get pass through authentication. 80% of replication problems are authentication. 19% of replication problems are connectivity. The 1% of problems that remain after this are actual problems to be fixed. Keep it simple and you will eliminate 99% of the problems you will encounter.
Mike
SQL Server MVP
Mike
SQL Server MVP
http://www.mssqlserver.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply