October 28, 2009 at 3:55 am
Hello every one,
Im trying to create a publication on SQL 2000 server and error 8526 is reported. I have set the trace flag (-T8599) and still error seems to be occuring. Can any suggest anything?
Ta
October 28, 2009 at 4:58 am
Hi,
Finally, I have decided to work on another SQL 2000 server and created 2 transactional updatable publication and created subscription on my SQL 2005 server on same database for two different table and Viola!!! it worked. This draws the conclusion that there is some connectivity or testing issue with my test server..
(To perform this test, I have created test table in live server and copied live data ).
At back of my head I need to solve the prioblem with my test server....
Ta
October 28, 2009 at 7:29 am
I think I might suggest removing replication from the 2000 test server and then resetting it up again. I have seen it flaky at times, and once it's off, it's hard to fix. Easier to remove and rebuild.
October 28, 2009 at 7:31 am
Steve Jones - Editor (10/28/2009)
I think I might suggest removing replication from the 2000 test server and then resetting it up again. I have seen it flaky at times, and once it's off, it's hard to fix. Easier to remove and rebuild.
Agreed. I would actually make sure that the database is removed from being a publisher and then go through the replication tables on the subscriber and make sure all that is cleaned up as well.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 28, 2009 at 8:33 am
Steve/David,
Thank you. I will try you (r) suggestion and will report..
Cheers
October 28, 2009 at 10:31 am
Hi,
I followed this post http://support.microsoft.com/default.aspx?scid=kb;en-us;324401 and did remove all publication,Subscription and Distributor. Configured SQL 2005 as Distributor/Subscriber and SQL 2000 (test server) as Publisher still getting error 8526.
I will reinstall SP4 and see if that works.
Cheers
October 28, 2009 at 11:24 am
Sorry to be a pain here but can you provide a simple overview again of what your layout is like? Something like the following;
Server1 - Publisher - Version
Server2 - Distributor - Version
Server3 - Subscriber - Version
I need a better mental picture. 😉
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 28, 2009 at 2:28 pm
Hi David,
Please find the present topology below
Server1 - Publisher - SQL 2000 - SP4 (Test Server/Live server)
Server2 -Distributor - SQL 2005 - (cannot remember sp) DEV server
Server3 - Subscriber - SQL2005 - DEv Server (Distributor and Subscriber are same server).
Dev server is running on new data model and needed data to be synchronized. I was experimenting with Transactional Repication for this purpose. Bit struggling with test server but live server connection is fine. Have to do some thing with test server testing.
Ta
Viewing 8 posts - 16 through 22 (of 22 total)
You must be logged in to reply to this topic. Login to reply