I'm using SSMS 2014 for SQL Server 2008 R2.
Why don't I see 'configure distribution' when I right-click on Replication?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
I found that the distribution and publication wasn't correctly disabled. When I tried to run the disable the publishing and Distribution (as seen in my image above) I was getting an error that the process couldn't complete because the distribution database was still in use. so I used
SELECT spid FROM sys.sysprocesses WHERE dbid = db_id('distribution')
to find the spid that was using it and then used
KILL <the spid>