Friday, March 23, 2012

failed to create SQL Server Agent Multi_Server Admin

Failed at the last step

Prompt: Window NT User or Group '.\Administrator' not found?

I used this account log on SQL Server Agent, What's wrong with this?

My OS is windows2000 sp4, MSSQL is 2005 sp1

any idea? thanks

I tried to use another account to log on SQL Server Agent

and I found the SQL Server Agent service account no longer needs to be a member of the local Administrators group on the box great!

However still failed to create Multi_server admin,any idea ?|||

Have you set the encryption options as directed here?

http://msdn2.microsoft.com/en-us/library/ms365379.aspx

jkh

|||

nope,the registry subkey MsxEncryptChannelOptions' value is 2

I change this to 0, but still could not working

|||Did you change it to 0 on all systems?|||

I'm setting Master Server

do i also need to set this on all target server at the same time?

|||

Your hypothesis is correct.

It is the target server that initiates the job download, and so it is the target server that needs the crypto options set.

Let us know if this works out,

Thanks,

jkh

No comments:

Post a Comment