Multi-server administration

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Multi-server administration

Multi-server administration

Rate Topic

Display Mode

Topic Options

Author

Message

Niyala

Posted Monday, September 01, 2008 7:44 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 26, 2013 4:59 AM
Points: 154, Visits: 409

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

Niyala

Post #561998

Steve Jones - SSC Editor

Posted Monday, September 01, 2008 8:43 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:47 PM
Points: 31,406, Visits: 13,722

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 »

Permissions