Can SQL Transactional Replication work between SQL 2005 Standard (Publisher) and SQL 2008 R2 Web (Subscriber)?

I've been trying, googling and hitting my head against the wall but can't figure our what the problem is or how to solve it.

I have and SQL 2005 Standard server acting as a publisher. I need to do transactional replication to an SQL 2008 R2 Web server on another location.

I've开发者_JAVA百科 set up the publication, and enabled FTP access to get the snapshot.

On the 2005 server when I launch replication monitor it keeps saying Uninitialized Subscription.

If I test this with a different subscriber that is running SQL 2008 Enterprise, it works fine.

Could it be because of the version? Could it be the SQL 2008 R2 Web can't work as a subscriber with SQL 2005?

Thanks, Federico

---

Mixed versions are supported, but:

• Distributor version must always be equal or newer than Publisher
• Subscribers for transactional replication can be within 2 versions newer/older of Publisher
• Subscribers for merge replication must be equal or older than Publisher

You need to troubleshoot to verify initial setup. I would suggest you to setup Replication using GUI http://www.sql-server-performance.com/2010/transactional-replication-2008-r2/ (Should be similar in SQL 2005) as well

• To do a clean installation please drop existing setup (Publisher, Subscriber, Distribution DBs)
• How to cleanup Replication Bits - http://blogs.msdn.com/b/repltalk/archive/2010/11/17/how-to-cleanup-replication-bits.aspx

---

The comment listed below is from our SQL PFE. I am still trying to get some documentation.

"Publisher version must be equal to or greater than the Subscriber version."