sql 2019 on linux pcs status error

陈建宇 1 Reputation point
2020-10-22T10:15:51.283+00:00

在SQLAG01节点上执行了下面的命令后在检查 pcs status的时候出现报错。环境中DNS使用的windows DNS server
pcs resource create sqlag ocf:mssql:ag ag_name=sqlag master notify=true
pcs resource create AVGListener ocf:heartbeat:IPaddr2 ip=192.168.31.206 cidr_netmask=24
pcs constraint colocation add AVGListener sqlag-master INFINITY with-rsc-role=Master
pcs constraint order promote sqlag-master then start AVGListener

34262-image-1.png

SQL Server | Other
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff
    2020-10-23T05:29:01.18+00:00

    Hi @陈建宇

    Sorry that I’m not familiar with Linux.
    Please make sure the Always on Availability Group is enabled and created.
    Here are some articles which might help:
    https://www.mssqltips.com/sqlservertip/5239/install-and-configure-sql-server-2017-availability-groups-on-linux--part-2/
    https://www.mssqltips.com/sqlservertip/5416/install-and-configure-sql-server-2017-availability-groups-on-linux--part-5/

    Best Regards,
    Amelia


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.