Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server Agent not starting
Message
De
19/02/2013 08:31:59
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Installation
Divers
Thread ID:
01566359
Message ID:
01566366
Vues:
37
In the Configuration Manager it was showing as Stopped. I could not find the SQL Server Agent Error Log.

I have subsequently changed the log on as to use the administrator account and that has worked, although I know this is a bad idea. I will try to get the IT admin to create a new user which I will add in as a SQL Server sysadmin and see if that works.

>What do you see in SQL Server Configuration manager? Did you check SQL Server Agent Error log?
>
>>
>>I have a SQL Server Standard 2008 R2 instance running which was upgraded from the Express version. This is on a Windows Server 2008 R2 machine set up as a domain controller.
>>
>>I am now trying to implement some Replication (following the Stairways series on sqlservercentral.com http://www.sqlservercentral.com/articles/Stairway+Series/72274/) and am getting problems due to (I think) the SQL Server Agent not running.
>>
>>First confusion is that under services.msc it states that the SQL Server Agent is running, but inside SSMS the SQL Server Agent node has a little white x inside a red circle indicating that it is not running. If I try to start it inside SSMS I get a message:
>>
>>Unable to start service SQLAGENT$SQLEXPRESS on server < my server name >. (mscorlib)
>>Additional Information:
>>The SQLAGENT$SQLEXPRESS service on < my server name > started and then stopped. (ObjectExplorer)
>>
>>The SQL Server Agent is set to log on as "Network Service".
>>
>>I have found lots of stuff about this on-line but nothing seems to work, or I am getting lost in the quagmire of too much information. Any guidance would be welcome.
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform