Score:0

Error when new publication on SQL Server 2019

za flag

I tried to create a new local publication on SSMS. It errored out and I figured I could just try again. I think it said something like there were no databases setup for transactional publications?

Now when I right click Local Publications on SSMS, and click New Publication, I get this error:

10.13.14.8 must be enabled as a Publisher before you can create a publication. In the following dialog box, enable this server as a Publisher.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=15.0.18142.0&EvtSrc=Microsoft.SqlServer.Management.UI.PubWizardErrorSR&EvtID=WarningPublisherNotEnabledAndEnableIt&LinkId=20476

Then it brings me to the distributer screen. I see 10.13.14.8 in there as a publisher. When I try to add it again as a publisher, nothing happens because it's already there.

enter image description here

Any ideas how to fix this or how to remove everything I did and start over? That is, without completely removing SQL Server?

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.