HIGHLOGIC.NET

If you get this message when try to edit a maintenance task:

‘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. (ObjectExplorer)

Chances are your MS SQL Agent isn’t running. Just start the service and you should be good. I would recommend going into servers and setup a recovery option to restart upon failure, this will keep a watch over it and start it if its stopped.

written by admin \\ tags: agent, books, configuration, Online, security, server, sql, stopped, xp

Check to see if the file has been blocked by Windows

In most cases the file may be blocked by Windows. Check the properties of the file, there may be a note saying This file came from another computer and might be blocked to help protect this computer To check for and unblock the file, follow these steps:

1.Right-click the blocked file and then click Properties.
2.In the General tab, click Unblock if the option is available.

written by admin \\ tags: 2003, cannot, file, microsoft, open, server, windows