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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 sql aerver agent error

Author  Topic 

rohans
Posting Yak Master

194 Posts

Posted - 2003-12-23 : 12:53:17
I got this error when I tried starting the SQL Server Agent with a domain account that currently starts the SQL Server.

Could not start the SQL ServerAgent Service on \\ SERVERNAME Error 2140: An internal Windows NT Error occurred.

I am still searching microsoft site.

What is the check box for that says: "allow interaction with desktop" for? In the startup parameter for the services. What does this allow and how is it useful?

All help appreciated.

rohans
Posting Yak Master

194 Posts

Posted - 2003-12-23 : 15:32:56
For the first time I get to answer my own question. Feeling like I am gaining knowledge. Well the account needs to be a local Administrator. And the interact with desktop is for using command line stuff, See more at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;152460 section 2 (b).

All help appreciated.
Go to Top of Page
   

- Advertisement -