SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Maybe it is time to switch to Ola Hallengren's maintenance solution: http://ola.hallengren.com?
SSMS Error with Create Credential in Maintenance Plan
![](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)
rr-4098
2,271
Reputation points
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???
SQL Server | Other
Answer accepted by question author
-
Erland Sommarskog 134.1K Reputation points MVP Volunteer Moderator2024-08-28T21:12:33.37+00:00
1 additional answer
Sort by: Most helpful
-
ZoeHui-MSFT 41,551 Reputation points2024-08-29T06:40:19.9566667+00:00 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.
-
rr-4098 2,271 Reputation points
2024-08-29T16:31:54.4066667+00:00 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.
-
rr-4098 2,271 Reputation points
2024-08-29T18:57:27.1566667+00:00 When I remove the value for Credential name for the task and run the maintenance plan is error with "Invalid zero length device name"
-
rr-4098 2,271 Reputation points
2024-08-30T18:54:56.2233333+00:00 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"
-
rr-4098 2,271 Reputation points
2024-08-31T19:06:41.0566667+00:00 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
-
rr-4098 2,271 Reputation points
2024-09-02T08:00:47.52+00:00 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'; -
rr-4098 2,271 Reputation points
2024-09-05T19:12:49.53+00:00 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.
-
rr-4098 2,271 Reputation points
2024-09-05T19:49:47.3066667+00:00 When I go to task -> back and use the same creds it works so it must be something with the syntax
-
Erland Sommarskog 134.1K Reputation points MVP Volunteer Moderator
2024-09-05T20:38:12.6566667+00:00 Sounds like something is mangled by the maintenance plans. I would call that a bug.
I can see two options:
- Open a support case. (And if it is indeed a bug, it should be of no charge to you.)
- Switch to Ola Hallengren's solution.
-
rr-4098 2,271 Reputation points
2024-09-05T20:43:24.49+00:00 When I do a task -> back how can I tell what syntax the job is using since these jobs complete successfully.
-
Erland Sommarskog 134.1K Reputation points MVP Volunteer Moderator
2024-09-05T21:21:21.0866667+00:00 Use the Script button on top.
-
rr-4098 2,271 Reputation points
2024-09-06T19:29:46.0766667+00:00 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?
-
rr-4098 2,271 Reputation points
2024-09-07T17:50:48.9733333+00:00 How can I accept a comment someone posted?
-
Erland Sommarskog 134.1K Reputation points MVP Volunteer Moderator
2024-09-07T20:04:15.85+00:00 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.
Sign in to comment -
