Link to home
Start Free TrialLog in
Avatar of Philip van Gass
Philip van GassFlag for South Africa

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 ?
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?
Avatar of Philip van Gass

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.