Skip to content

Tips

SQL 2014 'Agent XPs' componet is turned off when accessing Maintenance Plans

When trying to create a Maintenance Plan you get an error:  ‘Agent XPs’ component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Agent XPs’ by using sp_configure. For more information about enabling ‘Agent XPs’ see “Surface Area Configuration” in SQL Server Books Online. (Object Explorer) Details of the error are: =================================== Cannot show requested dialog. =================================== Unable to execute requested command. ——————————Program Location: at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolMenuItemHelper.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc) at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread() =================================== ‘Agent XPs’ component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Agent XPs’ by using sp_configure. For more information about enabling ‘Agent XPs’, see “Surface Area Configuration” in SQL Server Books Online. (Microsoft.SqlServer.Management.MaintenancePlanWizard) ——————————Program Location: at Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm.LoadData() at Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm..ctor(XmlDocument doc, IServiceProvider serviceProvider)   The Cause This is caused because the “SQL Server Agent” is not… Read More »SQL 2014 'Agent XPs' componet is turned off when accessing Maintenance Plans

ERROR The terminal server has exceeded the maximum number of allowed connections. RDP Solution

Using RDP from windows to access a remote server of Windows 2003. The problem sometimes appears that you cannot connect with an error reported as: ERROR The terminal server has exceeded the maximum number of allowed connections   The Problem The cause of this is that you have remote sessions that have not exited correctly. Either the connection to the server was lost, or the user simply clicked the close X at the top of the session. AND You have your settings in Terminal Server set to hold dropped or inactive sessions either for a period of time or forever.   To Solution At the Start Button on the computer where you would normally run Remote Desktop Connection from. Click Start Run Type in “mstsc.exe –admin” Then enter the connection details that you would normally use, and away you go.