Multiserver Administration SQL 2000

microsoft.public.sqlserver.tools

23 Aug 2006 10:56 AM

PetitGosaimass

Hello,

I am trying to set up multiadministration server, since my company has 2
central cluster servers, with SQL Server 2000 SP3, and 80 local sql server
2000 SP3.

I have recently upgraded a central to SP3, and did the same for a local sql
server.
both are in the same domain, started by an special administrator account for
SQL Server services (both SQL Server service and SQL Agent).
I'm thus using Windows authentification. I tried to set up both server for
mtltiadministration, using SQL queries :
==> EXEC xp_sqlagent_msx_account N'SET', N'', N'', N''
to run multiadministration server under SQL agent account, and then
==>
EXEC sp_grantlogin 'MyDomain\MyUser'
USE msdb
EXEC sp_adduser 'MyDomain\MyUser', MyDomain\MyUser', 'TargetServersRole'

on each server, both central and target (local).

Then I try to set up multiadministration using EM, but the 'Specify MSX
Account' step fails, saying the account I'm using is not a valid MSX Account.

I can't find any more help on forums and BOL.

Your help will be much appreciated....I'm eager to manage the 80 servers
with one...

Xavier Marcatel