Trying to backup database from SQL Server 2022 to S3 using S3:// connector but getting an error

Jashpinder Singh Gill 1 Reputation point
2022-08-29T11:26:56.42+00:00

Msg 3201, Level 16, State 1, Line 49
Cannot open backup device 's3://**********.com/sqlservertest/Testing.bak'. Operating system error 12002(failed to retrieve text for this error. Reason: 15100).
Msg 3013, Level 16, State 1, Line 49
BACKUP DATABASE is terminating abnormally.

Completion time: 2022-08-29T11:07:45.4244270-07:00

I have had already set the credentials for the endpoint:

CREATE CREDENTIAL [s3://*************.com/sqlservertest]
WITH
IDENTITY = 'S3 Access Key',
SECRET = '************:****************';

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,696 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Seeya Xi-MSFT 16,436 Reputation points
    2022-08-30T03:06:21.473+00:00

    Hi @Jashpinder Singh Gill ,

    Welcome to Microsoft Q&A!

    Operating system error 12002(failed to retrieve text for this error. Reason: 15100)

    If you have received this error 12002 on your PC, it means that there was a malfunction in your system operation. Error code "error 12002" is one of the issues that users may get as a result of incorrect or failed installation or uninstallation of software that may have left invalid entries in system elements. Other potential causes may include improper system shutdown, such as due to a power failure, someone with little technical knowledge accidentally deleting a necessary system file or system element entry, as well as a number of other factors.

    The following steps should help fix the issue:
    Download Outbyte PC Repair application
    Install and launch the application
    Click the Scan Now button to detect potential issue causes
    Click the Repair All button to fix detected abnormalities
    The same application can be used to run preventative measures to reduce the chance of this or other system issues appearing in the future.

    Best regards,
    Seeya

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.

  2. Jashpinder Singh Gill 1 Reputation point
    2022-09-06T09:11:58.383+00:00

    I was able to resolve it by getting a valid signed TLS certificate from the S3-Object Storage and loading it inside the Trusted Root Certificate Authority within the SQL Server Windows OS.
    This Thread may be closed