sql agent service failing

[vinod]

Whenever i change the SA password to anything else, my SQL Agent services
like jobs, alerts starts falling, and if i attempt to stop and then restart
sql agent service, it will not start again.

My server uses sql authentication for everything...

help...

thanks

vinod

[Paul]

set your SQL Agent to use Windows authentication via your services.

------------
vinod at 2/9/01 9:19:32 AM

Whenever i change the SA password to anything else, my SQL Agent services
like jobs, alerts starts falling, and if i attempt to stop and then restart
sql agent service, it will not start again.

My server uses sql authentication for everything...

help...

thanks

vinod

[vinod devasia]

I couldnt find anywhere in sql server agent service to set anything as
nt authentication or sql authentication...

Maybe the situation is not very clear, let me explain further

i have a network called as website... and it has a domain account called
as sqlservice

the sqlagent is set up to use the account

websitesqlservice

i also have a local admin account for the local machine. The sql server
is a cluster and the machine names are sql1 and sql2

help !

Vinod


------------
Paul at 2/9/01 9:24:00 AM


set your SQL Agent to use Windows authentication via your services.

------------
vinod at 2/9/01 9:19:32 AM

Whenever i change the SA password to anything else, my SQL Agent services
like jobs, alerts starts falling, and if i attempt to stop and then restart
sql agent service, it will not start again.

My server uses sql authentication for everything...

help...

thanks

vinod

[barb]

Right click on the sql agent and select properties, then click the tab connection. You can change the sa password there to match what
the current password is.


------------
vinod devasia at 2/9/01 10:42:06 AM

I couldnt find anywhere in sql server agent service to set anything as
nt authentication or sql authentication...

Maybe the situation is not very clear, let me explain further

i have a network called as website... and it has a domain account called
as sqlservice

the sqlagent is set up to use the account

websitesqlservice

i also have a local admin account for the local machine. The sql server
is a cluster and the machine names are sql1 and sql2

help !

Vinod


------------
Paul at 2/9/01 9:24:00 AM


set your SQL Agent to use Windows authentication via your services.

------------
vinod at 2/9/01 9:19:32 AM

Whenever i change the SA password to anything else, my SQL Agent services
like jobs, alerts starts falling, and if i attempt to stop and then restart
sql agent service, it will not start again.

My server uses sql authentication for everything...

help...

thanks

vinod