i have faced the same days ago, i think i have changed every password that the agent uses, and update the service account and still know why it was so...

in ur case then u r in a war, and in a war no one wins, every one will get heart its just how far u will go.

i think u...

i have faced the same problem, using sql login on both server did it.

can u consider using stored procedure to be used in the appliction, by this u can do every thing u can and if u used with encryption option he cant...

can u connect to the server using any other windows login,

means u r having this problem with any windows login or just this specifice one.

i did try this

declare @v_sql varchar(8000)

SET @v_sql = 'SELECT a.[appointmentslot_id], a.[slot_type], u.[display_name] as slot_type_desc,

a.[start_time], a.[location_id], l.[location_name], l.[domain_id], a.[effective_from],

...

am trying to use the code but the TSQLCommand is returning NULL??

CREATE TRIGGER ddl_trig_login

ON ALL SERVER

FOR Create_login

AS

PRINT 'Login Event Issued.'

...

its look like i have to move on, i have no choice.

thanks man.

so what caused the agent service from starting and making the server service to stop after trying to strat the agent too??

am trying to find out what happning but i...

ok it did worked.

can i give a user the permission to do every thing but not drop any object from the dbo schema?

and what about the agent, should i do the same for it, create its own SPN recored?.

is this case normal it shouldnt be right? i was very close to have...

this one is good, i think i could add some code to rollback the alter if the role was sysadmin, i think it might do the work.

thanks

its earlly for my company to use 2008, so am stick with 2005.\any way im trying to use the code in the post but am trying to recored AUDIT_ADD_MEMBR_TO_DB_RLOE_EVENT but...

hi

am having the same problem, and am wondering have u wrote this article or not??

i need to see ur solution.

thanks

i think u might create a shared folder and use its path on the job, and make sure that the sql agent have a write permission on the folder.