Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Multi-server administration Expand / Collapse
Posted Monday, September 1, 2008 7:44 AM


Group: General Forum Members
Last Login: Tuesday, December 15, 2015 4:01 AM
Points: 154, Visits: 467
Hi all,

Working under MS SQL Server Enterprise Edition, I have been trying to configure multi-server administration environment to administer some SQL servers out there in another building. I first tried to create a master server where I have SQL server jobs. I followed the procedures provided by MSX wizard. After i enlisted the target servers (TSX), I chose the windows authentication mode. However, I could not continue as I got the following error message:

The account 'localSystem' is not a valid MSX account. Contact the MSX administrator to get MSX account information.

I would apprecaite if anyone could give me a hint on how to continue with the configuration.

Thanks indeed

Post #561998
Posted Monday, September 1, 2008 8:43 AM



Group: Administrators
Last Login: Today @ 10:07 AM
Points: 34,375, Visits: 18,597
Multiserver administration means that the services running SQLAgent must actually connect to other instances. LocalSystem isn't an account that can connect to other servers. You will need to change the service account to one that can connect to the other instances.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #562019
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse