When setting up a distribution database using the wizard, if you select the second radio button from the below screen you need to already have configured the distribution database on this instance.
Please keep in mind that because SQL Server express edition doesn’t have a SQL Server agent you cannot have this instance setup as either publisher or Distributor.
In order to correct the above message you need to login to the instance which you were about to specify when pressing Add and go thru the distribution setup wizard first.
For details on how to setup a distribution database click here.
This post was written by Jayanth Kurup. A Microsoft SQL Server Consultant and Trainer based out of Bangalore, India. Jayanth has been working on MS SQL Server for over 15 years. He is a performance tuning and Business Intelligence expert. Having worked with companies like Microsoft, DELL, Wells Fargo, Thomson Reuters and many other fortune 100 companies. Some other technologies Jayanth works on include Microsoft Azure, PowerBI, Python and AWS. When he isn’t consulting or training, Jayanth like to travel, paint and read. He is also very active in social causes and the founder of Enabled Business Solutions. Visit his company by clicking the link in the menu or email him directly.