Return
-
Title
Error 'Data source name not found and no default driver specified' when running Clean up History task in maintenance plan in SQL 2022 -
Description
When running a Cleanup History job in a Maintenance Plan, the job doesn't run and the following error appears:
'Cleanup Backup,Maintenance plan,LiteSpeed history older than '20231207 13:23:00'
Msg 0, Level 0, State 0, Line 0: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Msg 0, Level 0, State 0, Line 0: [Microsoft][ODBC Driver Manager] Connection not open
[1] Execution Time: 0 hrs, 0 mins, 1 secs.'
-
Resolution
Please ensure to download and install a SQL Server Native Client from here on the machine running the task, as this is required for the History Cleanup to run successfully.