How to renew database mirroring certificates SQL Server AlwaysON on Linux
Ubuntu / SQL 25-06-2025, 20:07 sobir 988 0
I found next message in error log file /var/opt/mssql/log/errorlog:
For resolution this problem you should recreate certificates on primary and replica databases.
On primary server
1. Show current certificates
select name,expiry_date,* from sys.certificates2. Show endpoints
select * from sys.endpoints
select name,type_desc,port, * FROM sys.tcp_endpoints3. Create and export a new certificate
CREATE CERTIFICATE dbm2_certificate WITH SUBJECT = 'dbm2';
BACKUP CERTIFICATE dbm2_certificate
TO FILE = '/var/opt/mssql/data/dbm2_certificate.cer'
WITH PRIVATE KEY (
FILE = '/var/opt/mssql/data/dbm2_certificate.pvk',
ENCRYPTION BY PASSWORD = 'P@$$w0rd'
);4. Move a new certificate to replica server via ssh:
cd /var/opt/mssql/data
scp dbm2_certificate.* root@<node2>:/var/opt/mssql/data/On replica server
1. Change permissions of cert files:
cd /var/opt/mssql/data
chown mssql:mssql dbm2_certificate.*2. Import a new certificate in database
CREATE CERTIFICATE dbm2_certificate
FROM FILE = '/var/opt/mssql/data/dbm2_certificate.cer'
WITH PRIVATE KEY (
FILE = '/var/opt/mssql/data/dbm2_certificate.pvk',
DECRYPTION BY PASSWORD = 'P@$$w0rd'
);On both sides
ALTER ENDPOINT [Hadr_endpoint]
FOR DATABASE_MIRRORING (
AUTHENTICATION = CERTIFICATE dbm2_certificate
);This article describes how to create a SQL Server Always On availability group on Ubuntu 22.04....
ПодробнееAutomating the certificate renewal for a HAProxy service using a bash script....
ПодробнееMonitoring MySQL database service with Zabbix Agent....
ПодробнееHow to fix the user and login mapping after recreate?...
ПодробнееМониторим estimated recovery time репликационных баз SQL Server AlwaysON в Zabbix....
ПодробнееQuickly start a ClickHouse database server in a Docker container....
ПодробнееНовые комментарии
Цитата: FidoNet Цитата: sobir Цитата: FidoNet Спасибо за статью. Остальные
Цитата: sobir Цитата: FidoNet Спасибо за статью. Остальные статьи что находил
Цитата: FidoNet Цитата: sobir Цитата: FidoNet Можт быть дело в
Цитата: sobir Цитата: FidoNet Можт быть дело в dnsmasq.service? Ошибка Failed
Цитата: FidoNet Цитата: sobir Цитата: FidoNet Спасибо за статью. Остальные
Можт быть дело в dnsmasq.service? Ошибка Failed to set DNS configuration: Unit
Какой дистрибутив Linux вы часто используете?
Календарь
| « Ноябрь 2025 » | ||||||
|---|---|---|---|---|---|---|
| Пн | Вт | Ср | Чт | Пт | Сб | Вс |
| 1 | 2 | |||||
| 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| 10 | 11 | 12 | 13 | 14 | 15 | 16 |
| 17 | 18 | 19 | 20 | 21 | 22 | 23 |
| 24 | 25 | 26 | 27 | 28 | 29 | 30 |






