Data Replication in MSSQL server 2008 R2 Express

• pallavi.unde

  SSCommitted

  Points: 1987

  More actions

  April 21, 2012 at 1:04 am

  #256767

  Hello,

  I am using MSSQL server 2008 R2 Express Edition.

  I am adding publisher in it but it is showing error like

  "Server 'B3-C9\SQLEXPRESS' is neither a publisher nor a distributor, or you do not have permission to access replication functionality on this server"

  Not getting what actually this mean to say???

  can any one help me to get out of it????

  Thanks & Regards,
  Pallavi

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  April 21, 2012 at 2:47 am

  #1477023

  SQL server 2008 R2 express edition can only participate in replication as a subscriber!

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

  "Ya can't make an omelette without breaking just a few eggs" 😉