Showing posts with label ctp. Show all posts
Showing posts with label ctp. Show all posts

Wednesday, March 28, 2012

Replication Synchronization Error

I have a default full install of the JULY CTP on X86 Windows Server 2003 (fully up to date on the patches). I used the Merge Replication Sample to create the Publisher/Publication. SInce the code sample to create the subscriber doesn't work (apparently some major changes in the assemblies) I had to create the Subscription using the wizard. Both databases are on the same machine (adventureworks and adventureworksreplicated). When I try and sychronize the database the first time I get the following error.

Error loading custom assembly "C:\Program Files\Microsoft SQL Server\100\COM\BusinessLogic.dll", Error : "Could not load file or assembly 'C:\\Program Files\\Microsoft SQL Server\\100\\COM\\BusinessLogic.dll' or one of its dependencies. The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047)".

I did confirm that the assembly is there, but do not know what else to look for. The account the synch is running under is the local Administrator (not a good idea I know but just want it to work).

Any ideas?

Thanks

Steve Muise

Neudesic LLC

Two threads down is a workaround for what looks like might be your problem, can you give it a shot? If it doesn't work, then let us know.

Tuesday, February 21, 2012

Replication in SQL Server 2005

I just installed SQL Server 2005 CTP and I dont see any kind of enterprise
manager or anyway to setup replication. I look in Visual Studio 2005 and
still dont see anything that looks like you can setup replication. What am I
Missing?
its a little confusing - or perhaps a lottle confusing.
Open up Microsoft SQL Server Management Studio, go to view object explorer,
find your sql server, and connect to it. Right click on the replication
folder, select configure distributor, follow the prompts, then right click
on publications, select new publication.
To configure a subscription, right click on the subscription folder.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Hitsnorth" <Hitsnorth@.discussions.microsoft.com> wrote in message
news:45870B55-3064-4425-A6FF-77205DB659E0@.microsoft.com...
> I just installed SQL Server 2005 CTP and I dont see any kind of enterprise
> manager or anyway to setup replication. I look in Visual Studio 2005 and
> still dont see anything that looks like you can setup replication. What am
I
> Missing?