S2k5 -> s2k8 failuure
in [Replication]
|
Prev: Replication between Sql 2005 publisher and SQL 2008 suscriber
Next: a brand new query tool is out on beta, we need feedback, so you get a free copy
From: BigSam on 8 Feb 2010 10:02 We're in the process of relocation some SQL servers & upgrading from 2k5 to 2k8. I've created a number of transaction replications that are working well, but one is failing. The publisher & distributor are both configured on the 2k5 server. I connected from the 2k8 server & created a push transaction subscription. These steps were made for all the databases to be replicated. Also, we are going through a VPN tunnel, across the Internet. The publication is configured to use a domain account with dbo role on the databases to be replicated. The subscription uses a SQL account on the receiving databases, which has been given the dbo role on that end. I also added the same account & role on the databases to be published. The error message in the publication states: 'You do not have permission to use the bulk load statement. (Source: MSSQLServer, Error number: 4834) Get help: http://help/4834 You do not have permission to use the bulk load statement. (Source: MSSQLServer, Error number: 4834) Get help: http://help/4834' The error appears to be related to applying the initial snapshot to the receiving database. I've check the user account on the publisher & the subscriber. They are OK. I did find that on the publishing end all the databases except the one in question had been 'magically' assigned 2 new roles: MSReplPAL_27_1 & MSRepl_PAL_role, in the domain account used to publish them. I added these 2 roles to the database user in question. I'm sorta @ the end of things to try. Any advice would be helpful. Thanks in advance. BigSam |