Many companies do hardening of servers to make sure they are protected from any known vulnerabilities. It is important to test all the application in test server before doing hardening. Let us learn about how to fix Eventlog Service not starting.
SQL SERVER – Express and SQL Server Agent – Free Alternative
“How come my database is only a few MBs big and I am facing performance problems?” My customer asked. I replied, “Well, this is because you are not running job using SQL Server Agent to keep your indexes in the best health.”
SQL SERVER – Displaying SQL Agent Jobs Running at a Specific Time
Recently I was troubleshooting at a customer location something that looked trivial. When the customer approached me for a consulting requirement wherein they were saying their system was going unresponsive every day in the morning around a certain time. They were clueless to what is happening and why this was the case almost every day in the week. I got curious to understand what was going wrong with SQL Agent Jobs.
SQL SERVER – Error: 14258 – Cannot perform this operation while SQLServerAgent is starting. Try again later
One of my clients asked assistance in fixing an interesting issue. They informed me that they are not able to run any job in SQL Agent. When they try to run the job manually, they are seeing below message related to SQLServerAgent .
SQL Server Agent – Unable to start the service – The request failed or the service did not respond in a timely fashion
Rarely, it also happens when someone becomes accidental DBA and may get stumped with simple things. This blog is result of troubleshooting which I have done for a company where I found one such DBA. I don’t say you cannot become a DBA in this manner, it is the hard work that goes behind this that needs to be understood. Let us learn about error related to SQL Server Agent.
SQL SERVER – Unable to Start SQL Agent – SQL Server Agent Terminated (Normally)
Along with performance issues, I also provide consultancy in other break-fix issues like service not starting etc. These are not run of the mill, but on specific cases only. I always suggest my clients to search on my blog first and then contact me if needed. This is a great way to scale and make people empowered when it comes to solving some of the trivial issues that they might have encountered for SQL Server Agent.
SQL SERVER – FIX – Agent XPs Component is Turned Off as Part of the Security Configuration for this Server
One of my clients has installed a new instance of SQL Server and then wanted to create maintenance plan. They were complaining about getting some error and we’re looking forward for my help to solve the same. As soon as he did right click on a Maintenance Plan under “Management” node and selected “New Maintenance Plan Wizard” using SQL Server Management Studio as shown below. Let us learn how to fix Agent XPs Component is Turned Off as Part of the Security Configuration for this Server error.