What steps should I take if I suspect a corrupted SQL Server Agent installation is causing Error 1067?

Question

Grade: Education Subject: Support
What steps should I take if I suspect a corrupted SQL Server Agent installation is causing Error 1067?
Asked by:
102 Viewed 102 Answers

Answer (102)

Best Answer
(854)
If you suspect a corrupted installation, particularly after an unsuccessful update or patch, consider these steps: 1. **Run SQL Server Installation Repair**: Open 'Programs and Features' from the Control Panel, select your SQL Server installation, and choose 'Repair'. This process attempts to fix corrupted files without re-installing. 2. **Apply Latest Service Pack/Cumulative Update**: Sometimes, a known bug leading to corruption might be fixed in a later update. Ensure your SQL Server is fully patched. 3. **Check File System Integrity**: Run `chkdsk` on the drive where SQL Server is installed to rule out file system corruption. 4. **Re-install (as a last resort)**: If repair fails, a full uninstallation and re-installation of the SQL Server instance (including Agent) might be necessary. Back up all databases and configurations first.