Job config overwrites database credentials of the other job


#1

Hello,
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.

in ex.:
job1
server: sql.myname.nazwa.pl
user: user1
password: password1
db: db1

job2
server: sql.myname.nazwa.pl
user: user2
password: password2
db: db2

job3
server: sql.myname.nazwa.pl
user: user3
password: password3
db: db3

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?


#2

According to your topic - each SQL server has more than one user. Please update your title to help other SQLBackupAndFTP users finding a solution to what I could call “Job config overwrites database credentials of the other job”


#3

Hi Tomasz_Mazur,

Could you please install the following Alpha edition http://sqlbackupandftp.com/download/alpha then go the connection settings, specify Server name like:

localhost /* any description of the connection */
localhost /* connection for the second user */
localhost /* any other connection */

and use different credentials.

SQLBackupAndFTP

If you have any additional questions, please feel free to contact us.


#4

Hi Alexander,
I’ve tried this solution on allready installed version and it works excelent.

Thank you for your help :slight_smile:


#5

Hi Tomasz_Mazur,

That’s great! Thank you for your reply.

Please feel free to contact us on any issues or concerns.