I have problem with backup from sql. I have 3 different databases on one sql server. Every database have different user accounts and this is impossible to use one account for all databases - when I try there was a message from provider that this user allready exist).
When I have created backup jobs with MySQL server (TCP/IP) only one of them work properly because when i gave credentials for new database on that server, it was replace credentials on previously created tasks.
After this all jobs have credentials from job3, so job1 and job2 failed. When I changed credentials for job1 it was changed on all of them so job 2 and job3 failed.
Is there any way to do this?