SQL Server Performance Forum – Threads Archive
Replication – Data Push problem
Hi, We are trying replication for our disaster recovery project. we r using transactional replication. The snapshot job was run successfully.The log reader job was also run successfully. But the Push job says" Cannot push data since SQL server not available or access denied".But I am able to ping subscriber, open isqlw prompt of the subscriber, register subsciber on the publisher etc. But problem occurs only in pusing data. Please let me know if you have come across such problem. Regards Riya
Hi,<br />please refer :<br /><a href=’http://support.microsoft.com/default.aspx?scid=kb;en-us;827422′ target=’_blank’ title=’http://support.microsoft.com/default.aspx?scid=kb;en-us;827422′<a target="_blank" href=http://support.microsoft.com/default.aspx?scid=kb;en-us;827422>http://support.microsoft.com/default.aspx?scid=kb;en-us;827422</a></a><br /><br />And <br /><br />Potential Causes for SQL server not available or access denied <br /><br /><a href=’http://support.microsoft.com/kb/328306/’ target=’_blank’ title=’http://support.microsoft.com/kb/328306/'<a target="_blank" href=http://support.microsoft.com/kb/328306/>http://support.microsoft.com/kb/328306/</a></a><br /><br />HTH<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
THis happens with a mismatch of MDAC version between both servers, so check it out. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>