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

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

extracting data

I have the following informaton in a field called: full_path
/Capital Improvements Program/Management/Facilities/Lower South Platte/New
Util Admin Bldg/Ops Ctr/Planning
How can I pull out the information independently from the 2nd and 3rd level
or the 2nd and 3rd level combined. re: /Management
or /Facilities or combined /Management/facilities ?For such problems, if you have to do this at the server, use a table of
Numbers. That will make the solution more generic and flexible.
CREATE TABLE Nbrs ( n INT NOT NULL PRIMARY KEY );
And populate the table with numbers from 1 to 8000. Search the archives of
this newsgroup for several shortcuts to generate such sequential numbers.
And the query assuming the string always start with a '/':
DECLARE @.s VARCHAR(200), @.level INT
SET @.s = '/Capital Improvements Program/Management/Facilities/Lower South
Platte/New Util Admin Bldg/Ops Ctr/Planning'
SET @.level = 3
SELECT SUBSTRING( @.s, n, CHARINDEX('/', @.s + '/', n ) - n )
FROM Nbrs
WHERE n BETWEEN 2 AND LEN( @.s ) + 1
AND SUBSTRING('/' + @.s, n, 1) = '/'
AND n - LEN(REPLACE( LEFT( @.s, n ), '/', '' ) ) = @.level ;
For reuse and ease of maintanence, you can make it a procedure or scalar
UDF, depending on your requirements.
Anith