Nope, using the same admin account accross the board, I have gotten a connection error earlier. So I then added that admin account to the administrators group and this this...

It's happening on the publisher on the snap shot agent, it starts to bcp my articals then it fails with this error. I have 127GB on the drive so I...

Let me know I could use all the help I can get.

I think I found the issue, Running around in circles is fun!

thanks!

it excuted with zero rows affected

I have no idea, is there a query I can run to find out.

I just love going behind others work. :w00t:

Go it! Thanks

On the 2005 box I mad a publication for my DB

On my 2008 box I made a subscription using distributor (pull) option

so this will pull the original DB...

I get this error when making it a subscriber on the 2008 box

TITLE: New Subscription Wizard

------------------------------

SQL Server could not create a subscription for Subscriber 'ECA-DC-SQLREP1'.

------------------------------

ADDITIONAL INFORMATION:

An exception occurred while executing...

Sorry both DB's are 9.0 but one of them is on the 2008 server which is 10.

Roy,

I cannot get the server to connect when adding a new...

One server (2005) is 9.0

second server (2008) is 10

When setting up the Publisher can I select a higher level?

Does anybody know how to replicate a DB from 2005 to 2008? It will not let me add 2008 as a subscriber? any ideas?