Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL 2005 Agent error will not start

Author  Topic 

emailuser
Yak Posting Veteran

74 Posts

Posted - 2011-03-24 : 09:10:44
Hi, our SQL agent on our 2005 server will not start we always get the error
any help greatly appreciated ....

Current thread must be set to single thread apartment (STA) mode before OLE calls can be made. Ensure that your Main function has STAThreadAttribute marked on it. (System.Windows.Forms)

------------------------------
Program Location:

at System.Windows.Forms.Clipboard.SetDataObject(Object data, Boolean copy, Int32 retryTimes, Int32 retryDelay)
at System.Windows.Forms.Clipboard.SetDataObject(Object data, Boolean copy)
at Microsoft.NetEnterpriseServers.ExceptionMessageBoxForm.CopyToClipboard()

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2011-03-25 : 11:41:58
how and where do you get the error?

--------------------
keeping it simple...
Go to Top of Page

emailuser
Yak Posting Veteran

74 Posts

Posted - 2011-03-25 : 11:52:32
Hi , the sql agent is always showing as not started , in enterprise manager and windows service , not sure how long it has been like this, right clicking and selecting start in enterprise manager gives the error below , also through windows services it starts and stops straight away
Go to Top of Page
   

- Advertisement -