Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Error 'Data source name not found and no default driver specified' when running Clean up History task in maintenance plan in SQL 2022
설명
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.'
해결 방안
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.
