Philip van Gass
asked on
A Task Scheduler problem
I have a script that takes backups of a client's SQL Server databases at a specific time every evening using Task Scheduler.
We then installed SQL Server 2014 at the client so this necessitated me having to re-install my backup script and recreate the Task Scheduler job.
Now it gives this error: " Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : Login failed for user 'AFRICASUNOIL\abdulhamid'. ."
Can someone help ?
We then installed SQL Server 2014 at the client so this necessitated me having to re-install my backup script and recreate the Task Scheduler job.
Now it gives this error: " Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : Login failed for user 'AFRICASUNOIL\abdulhamid'.
Can someone help ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Have you had a chance to test the ODBC driver connection with that account to rule out whether this is a driver/compatability issue or a specific user account issue?
ASKER
Hi Eric,
The last one of your question suggestions was the cause of the problem.
The user concerned had not been recreated on the new server.
Thanks.
The last one of your question suggestions was the cause of the problem.
The user concerned had not been recreated on the new server.
Thanks.