[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Error when I try to start the SQL Server Agent

Posted on 2007-11-14
2
Medium Priority
?
783 Views
Last Modified: 2008-02-01
Hello guys

I am trying to start the SQL server agent and I am having the following error :

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)


These information I have in the log created

11/14/2007 08:22:17,,Information,[098] SQLServerAgent terminated (normally)
11/14/2007 08:22:17,,Error,[382] Logon to server 'SVHTSQL\SQL2005' failed (DisableAgentXPs)
11/14/2007 08:22:17,,Error,[298] SQLServer Error: 785<c/> Cannot generate SSPI context [SQLSTATE HY000]
11/14/2007 08:22:17,,Error,[298] SQLServer Error: 785<c/> SQL Network Interfaces: Nenhuma autoridade pôde ser contatada para autenticação. [SQLSTATE HY000]
11/14/2007 08:22:17,,Error,[000] Unable to connect to server 'SVHTSQL\SQL2005'; SQLServerAgent cannot start
11/14/2007 08:22:17,,Error,[298] SQLServer Error: 785<c/> Cannot generate SSPI context [SQLSTATE HY000]
11/14/2007 08:22:17,,Error,[298] SQLServer Error: 785<c/> SQL Network Interfaces: Nenhuma autoridade pôde ser contatada para autenticação. [SQLSTATE HY000]


What must I do to fix this?

Thanks
0
Comment
Question by:hidrau
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
SQL_SERVER_DBA earned 1000 total points
ID: 20279716
0
 
LVL 1

Author Comment

by:hidrau
ID: 20279855
Hi, could you tell me why I got that message and problem?

Thanks
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question