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 muchthank you
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
answered Jul 05, 2011 at 11:54 AM
please i await replies to my post what has gone wrong with the installation
answered Jul 05, 2011 at 03:10 PM