database backup to azure storage container failing

Question

Dear fellows,

i am trying to backup on pemised database to azure storage container, but getting this error,

Msg 3271, Level 16, State 1, Line 13
A nonrecoverable I/O error occurred on file "https://abcd.blob.core.windows.net/abcd/abcd_Jun21.bak:" Backup to URL received an exception from the remote endpoint. Exception Message: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel..
Msg 3013, Level 16, State 1, Line 13
BACKUP DATABASE is terminating abnormally.

i have created the credentials and then backing up using the commnad
BACKUP DATABASE abcd
TO URL = N'https://https://abcd.blob.core.windows.net/abcd/abcd_Jun21.bak'
WITH credential = 'SQLBackupsREC';
GO

Answer 1

Hi,

>Msg 3271, Level 16, State 1, Line 13
>A nonrecoverable I/O error occurred on

The error should be related to the credential you used in the backup statement.

what is your on-premises SQL Server version.

For 2016 and later, please refer to this doc.
https://learn.microsoft.com/en-us/sql/relational-databases/tutorial-sql-server-backup-and-restore-to-azure-blob-storage-service?view=sql-server-ver15&tabs=SSMS

For SQL Server 2014 and prior, use Tutorial: SQL Server 2014 Backup and Restore to Microsoft Azure Blob storage.