When setting up replication on an SQL-Server 2012 we accidentally set the name for the distribution-db to the name of one of our user-db's.
The user-db had all the distribution objects in it and showed under "system databases" in ssms. After we realized this, we removed all replication and distribution on the server; our database showed outside system again, and we removed all distribution objects from it.
We then proceeded to set up distribution again, this time using the name "distribution09" for our distribution-db. All went well - however when trying to set up replication on the mentioned user-db, it fails:
"Meldung 208, Ebene 16, Status 1, Prozedur syssubscriptions, Zeile 1
Ungültiger Objektname 'dbo.IHsubscriptions'."
It is possible to create the table 'IHsubscriptions' in our user-db; after that setting up replication will fail on the NEXT needed object. Therefore, it seems the server is still trying to use our user-db as the distribution-db.
Using the following commands shows the correct 'distribution09' in all the right places as the current distribution-db:
SELECT is_distributor FROM sys.servers WHERE name='repl_distributor' AND data_source=@@servername;
SELECT name FROM sys.databases WHERE is_distributor = 1
Any idea, how this can be fixed?
Thanks in advance,