This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER4%3C/text%3E%3C/svg%3E)
I was able to backup an onprem SQL DB to an Entra Storage account without issue. The problem is when I try to backup the DB using a maintenance plan I get the error below. I have been reading how to resolve this online and have already tried upgrading to the latest release of SSMS which did not help. I also tried to update the SSMS.exe.config file with the assembly listed and got the same result.
Thoughts???
Maybe it is time to switch to Ola Hallengren's maintenance solution: http://ola.hallengren.com?
Hi @rr-4098，
Here is a same thread and someone said that he solved with below.
you cannot create the credential in the new task dialog box or wizard.
After following those instructions, create the plan with the credential you need, setting the URLs, etc. After the task is created, click on the task and open the Properties panel and remove the value for "CredentialName":
"Sql Credential:" in the task box should be empty.
Save the plan and it will execute! Hope this helps.
You may carefully take a reference to.
Error when creating SQL Credential in SSMS 19
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
The you for the feedback. I saw that article as well. The problem is I get the same error when selecting the cred from the drop down.
When I remove the value for Credential name for the task and run the maintenance plan is error with "Invalid zero length device name"
I have tried replacing the URL with the SAS I generate in Azure and still the maintenance plan fails : "Cannot open backup device. Operating system error 50"
I found the following article https://www.sqlshack.com/backup-sql-databases-to-azure-using-the-database-maintenance-plan and getting a different error which is nonrecoverable IO error and from what I have found it related to the credentials
Still having 0 luck with this. I have read using a SAS with the following format but when I do this I get invalid null device. If I try to use the access key I get 403 forbidden and the storage account firewall is wide open. So far all of the suggestion I have tried has failed.
CREATE CREDENTIAL [https://xxx.blob.core.windows.net/container]
WITH IDENTITY = 'SHARED ACCESS SIGNATURE',
SECRET = 'sv=xxx';
I have tried countless articles on creating the creds with SAS and believe I have it right now. The problem is I keep getting operating system error 50. There is not a "?" in front of my SAS token, there are no network restrictions \ firewall in place. Plus I have an Access Policy in place which is wide open and good for one year. Any suggestions I am really stuck with this one.
When I go to task -> back and use the same creds it works so it must be something with the syntax
Sounds like something is mangled by the maintenance plans. I would call that a bug.
I can see two options:
When I do a task -> back how can I tell what syntax the job is using since these jobs complete successfully.
Use the Script button on top.
I gave up on the maintenance task and used Ola Hallengren's which seems to be working so far. Can the backup be set to back up all DB's instead of user DB's. Also it appears a maintenance task to remove old backups cannot access a URL location. Is this correct?
How can I accept a comment someone posted?
Well, you can't. But if it was my initial comment you had in mind, I have converted it to an Answer, so you can accept that one.