|
Please help I am new to SQL and willing to get a handle on it i have recently installed an evaluation copy which seems to have installed ok, but when i try to start the sql server agent, i get this message: unable to start service sqlserveragent on server . mscorlib please see error log below i have tried to research on the net about resolutions to this query but it still not working my sqlagent.out file contains info please if anyone can help check this out and advise me on what to do, i'll appreciate it much thank you
(comments are locked)
|
|
no my machine is a standalone one, not on any domain or workgroup when i installed sql server i followed the instructions in a cbt and created s seperate local user account for the database engine which is what was advised in the cbt asper the computer name with a dash, i think it was when i first bought the computer ages ago that i named it so and didnt think it would be a problem then the agent XPs is also an issue, i executed the follow script sp_configure 'show advanced options','1' RECONFIGURE go sp_configure 'Agent XPs','1' RECONFIGURE go when executed, it comes up with this message Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install. Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install. then the agent xp disappeared after refreshing and after a while it came back again, the sql server agent in ssms has a red arrow pointing downward which is why i know something is wrong in the event viewer, i get something like this FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'. Configuration option 'Agent XPs' changed from 1 to 1. Run the RECONFIGURE statement to install. please any advice/help will be appreaciated Open up your Windows System and Application logs and see if there is anything in there (errors/warnings) that are related.
Jul 05 '11 at 12:25 PM
SirSQL
(comments are locked)
|


Is your machine on a domain or a workgroup? Did you set SQL Server and SQL Agent to use a domain account, a local service account, or a local Windows account? Another issue might be the dash in the name - this isn't a good idea for machine names. The kerberos messages may just be red herrings... do you have Agent XPs enabled? In SSMS / Object Explorer what does the icon for SQL Server Agent look like?
You might want to also check the Windows Event log to see what messages show there.