Heeeeelp me please
My sql server 8(sp3) runs ok, but the sql server agent don't starts.
Is configured to start at the os startup, and I tryed to start it manually...
In the Log Viewer of windows I can see:
<<Error ID- 103
SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start). >>
what account is sql server / agent both running as?
is agent configured to use windows or sql authentication when connecting to the server? does it have an account with the necessary priveleges?
(right click on the agent in enterprise manager and check its settings)
run @@servername and make sure server name is not null...
@@servername is a T-SQL command - will return the name your server responds to (ie. on a machine called Foo, the @@servername value would by default also be Foo.
Sometimes this value is missing and can cause connectivity problems - probbably not the case here but worth checking (since you error message referes to sql as 'local', not a name (not necessarily a problem))