Replication - Distribution database doesn't appear under System Databases

• christy.umoren

  SSCommitted

  Points: 1654

  More actions

  October 30, 2014 at 8:41 am

  #300531

  Hi all,

  i just finished installing SQL Server 2012 with the SQL Server Replication feature component checked. On configuring transaction replication, i notice the distribution database wasn't there. I ran the below query

  EXEC sp_get_distributor

  And the value for distribution_db_installed is 0 as shown below

  installeddistribution serverdistribution db installedis distribution publisherhas remote distribution publisher

  0NULL000

  Any help on whats going on?

• BrainDonor

  SSCoach

  Points: 19254

  More actions

  October 30, 2014 at 10:11 am

  #1755839

  You've installed SQL Server with an option to cater for Replication but you haven't actually set up any Replication yet.

  Once you create a Publication a Distribution database will be created as part of that.

  Steve Hall
  Linkedin
  Blog Site