Getting this warning when trying to setup a transactional replication. This error occurs when setting up a subscription from sql server express
using non impersonated login to the distributor. this works using sql server developer
subscrption to sql server workgroup
publication but not from sql express
to sql workgroup
. Im not sure if it is an issue with the agent or what not but the subscription setup is identical to my working subscription other than the ability to choose the login to the sql server agent.
views:
21answers:
1
A:
If I'm reading this correctly, you're trying to use SQL Server Express as your publisher. SQL Server Express can only be a subscriber in a transactional replication.
http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx#integration
Joe Stefanelli
2010-06-24 21:35:01
no im using workgroup as a publisher and sql express to subscribe
Ayo
2010-06-25 13:41:09