Trying to activate Replication on a new installed SQL Server, I don't know exactly which step has changed my distribution database, to point to another of my production databases.
Now, from SSMS, when I go to:
- Right Click on Replication > Publisher Properties
Distributor: This server acts as its own distributor
Distribution database: MasterD (this is one of my production databases, and this should be distribution, and not MasterdD)
- Right Click on Replication > Distributor Properties
Error message: SQL Server is unable to complete the Distributor Properties.
Could not refresh properties of this object from server. Check if this object still exists on the server.
I would like to set the distribution system db as Distribution database again, and quit MasterD.
And fix the error when try to access to Distributor Properties.
All your help will be appreciate.