September 26, 2008 at 1:44 am
hi,
i have established linked server between srvr1 and srvr2 one month back
so what happens from last couple of days
SQLAGENT90.EXE (commad prompt) running on desktop of svrv2 ...
but if i stop sql server agent at srvr2 ..it stops....
i dont know why this is happening.please help
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 26, 2008 at 2:48 am
Check Administrative Tools/ Services/SQL Server Agent. Is your agent running under the local service account? If so, there will be a checkbox underneath 'Allow service to interact with the desktop'. If that's checked it could be the cause of your problem. Uncheck it and see if that helps.
Cath
September 26, 2008 at 3:12 am
thanks ..i deselect that option ..and it works.:).i dont know who had selected that ?
but by the way ....why this option is used for ???
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 26, 2008 at 3:38 am
Hmm, was hoping you wouldn't ask that - I'm not a programmer, I just stumbled across that fix a while ago. I think it may have something to do with developing programs that run as a service - the gui may need to send messages to the service? But I could be totally wrong. Maybe someone else could tell us?
Cath
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply