SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Snapshot Replication


Snapshot Replication

Author
Message
jayjj
jayjj
Valued Member
Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)

Group: General Forum Members
Points: 56 Visits: 188
Hi Guys,

I am in the middle of an upgrade to SQL server 2012 from 2005, however we want to keep one of our server on SQL 2005 as it has a Database published as a Snapshot replication.

My Question is are we able to do a Push of the Published database into one of our SQL 2012 server ? A pull of the data as a Subscriber works from the SQL 2012 server, however doing a push to the same subscriber SQL 2012 server from the 2005 server does not work.

Main message Error: 14151, Severity: 18, State: 1.

I have tried to set the agents with the same Domain account but still got the same error, so just wondering if the version is the issue here.

Thanks
MyDoggieJessie
MyDoggieJessie
SSCertifiable
SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)

Group: General Forum Members
Points: 6668 Visits: 7394
I believe there is an issue with your Log Reader Agent (you probably already know this) - it could be because something is blocking it on the publisher so check there...

Have you tried to re-initialize the 2012 subscription?

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience" ;-)
jayjj
jayjj
Valued Member
Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)

Group: General Forum Members
Points: 56 Visits: 188
MyDoggieJessie (3/12/2014)
I believe there is an issue with your Log Reader Agent (you probably already know this) - it could be because something is blocking it on the publisher so check there...

Have you tried to re-initialize the 2012 subscription?



Thanks for the reply, yes i have re-initialize the 2012 subscription, we have tried all sorts with this, but i found a blog which said this that the alias could be the issue as they are not the same. The Blog seems to suggest you cannot push from a 32bit to a 64bit platform unless you create identical alias in both 32bit and 64bit “SQL Native Client 10.0 Configuration” panes, however the issue now is that i am not able to test this as my install only has a SQL Native for 32bit.


http://blogs.msdn.com/b/repltalk/archive/2010/04/26/distribution-agent-fails-with-error-locating-server-instance-specified-xffffffff.aspx
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search