Forum Discussion
JonCi90
Aug 02, 2023Copper Contributor
Error when creating SQL Credential in SSMS 19
Hi all, I recently installed SQL Server 22 CU4 and SSMS 19.1.56.0 on a new VM in Azure running Server 2022 Datacenter. When attempting to setup a maintenance plan with a backup, I receive the...
DrewB2455
Jul 18, 2024Copper Contributor
Hi all -
I had great success with Woody0 's instructions up above. As they state, 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.