July 18, 2012 at 3:16 am
Hi Folks,
Trying to keep a database on two servers in sync using Merge replication.
Server A: Standard Ed, X86, version 10.50.1600.1
Server B: Standard Ed, X86, version 10.0.5500.0
Merge replication from A to B works perfectly.
Merge replication from B to A fails with the following message on Server B:
Source: wsus-alb (Server A)
Number: -1
Message: SQL Server Network Interfaces: Server doesn't support requested protocol [xFFFFFFFF].
2012-07-18 02:00:31.439 Category:SQLSERVER
Have checked:
- All protocols enabled except VIA
- Accounts used in replication exactly the same on both servers
- Ping from A to B and B to A successful
- Can connect to either datatabase using Management Studio
Any suggestions?
July 18, 2012 at 3:41 am
your running SQL 2008r2 and SQL 2008 see if this helpshttp://msdn.microsoft.com/en-us/library/ms143241%28v=sql.105%29.aspx
July 18, 2012 at 3:53 am
Thank you
Confusing. Do you suggest upgrading to R2?
July 18, 2012 at 4:00 am
It depends on what the other SQL instance is used for, it will simplify things like replication, for merge replication you will still need to look at the points in the document. Also keep in mind that if your licenced for SQL 2008 you will need to upgrade to use SQL 2008r2
July 19, 2012 at 4:09 am
I set up a test box with SQL 2008R2 on it and it works perfectly both ways.
It seems R2 can replicate to 2008, but not from 2008 to R2.
July 19, 2012 at 4:33 am
Thanks for the update, I knew 100% that that was the case with transactional replication but i've only done 1 or 2 implementations of merge replication (using 2005) so wasn't totally sure if that was the case when using 2008 + 2008r2. Glad you worked it out
Mike
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply