The 'Publish and Subscribe' feature does not work on SQL Server2019 installed using Docker technology on Linux

王 荣 0 Reputation points
2024-04-22T06:34:16.5366667+00:00

Database server information : Linux (Rocky 9.1) , Podman platform install (A kind of docker technology),SQLServer 15.0.4033.1(2019)，docker image downloaded from the microsoft website,The service startup command is: podman run --name mssql2019 --net=host -e 'ACCEPT_EULA=Y' --hostname xztest -e 'MSSQL_PID=xxxxxxxxxx' -e 'TZ=Asia/Shanghai' -e 'MSSQL_COLLATION=Chinese_PRC_CI_AS' -e 'SA_PASSWORD=Pass$560' -e 'MSSQL_AGENT_ENABLE=true' -v /opt/mssql/:/var/opt/mssql/ --privileged=true -d d9a794d43768, The “MSSQL_PID” parameter has been hidden for privacy reasons.
After completing the above installation and startup,I use "Microsoft SQL Server Management Studio 18" for connection and database management. since my platform is in a Chinese enviroment,some prompts are manually translated by me,which may differ from the original English version,but the general meaning is similar,At the same time,I will provide an original Chinese prompt,which roughly translates to :"You must first enable 10.1.3.215 as the publishing server before you can create a publication. In the following dialog box, enable this server as the publishing server.", the Chinese message is:"必须先将 10.1.3.215 作为发布服务器启用，然后才能创建发布。在下列对话框中，将此服务器作为发布服务器启用。"

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,755 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MikeyQiao-MSFT 560 Reputation points Microsoft Vendor
    2024-04-23T07:23:56.2166667+00:00

    Hi，王 荣

    Welcome to Microsoft Q&A!

    Configuring replication on Linux is indeed different from doing so on a Windows operating system, even though you are using a Docker environment (which still relies on the Unix kernel). You will need to configure replication through T-SQL. This article details the implementation process：

    Configure Replication with T-SQL

    Best regards，

    Mikey Qiao

    If the answer is helpful, please click "Accept Answer" and upvote it.