I'm having a major issue with my WSUS setup. The administration console can't connect to the WSUS Server Database, and I'm getting an error saying 'Execution Timeout Expired.' I've checked, and the SQL server should be running fine. I also restarted SQL, but the problem persists. Can anyone offer some guidance on what steps to take next?
3 Answers
You might want to check your disk space or if the service is running properly. WSUS uses a version of SQL called Windows Internal Database. If issues keep arising, I’d recommend considering replacing the WSUS server altogether. They can be pretty disposable once they start acting up, which can save you a lot of headaches.
Did you verify if the SQL server is actually up and running? Sometimes that's the root of the issue. Don't forget to check the service status, just in case! 🙂
It sounds like your WSUS database may need some maintenance. It's prone to corruption if not regularly cared for. If it's really bad, consider just setting up a new instance. As long as it has the same IP and port, your devices will reconnect without any hassle. I'd recommend switching from the default Windows Internal Database to SQL Express for better stability. Here’s a brief guide on how to do it: 1. Install SQL Express and Management Studio. 2. Configure WSUS to use SQL. 3. Follow best practices for IIS running WSUS. 4. Automate maintenance tasks. Check out this YouTube link for help: https://youtu.be/p2DeMEKXw4k.
Absolutely! I always maintain a synchronized backup for my WSUS server. The moment I notice any problems on the main server, I power it off, switch to my backup, and update DNS. Then I just wait a day for everything to check in while I build a new backup from scratch.