Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 1:27 AM
Points: 154, Visits: 437
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
Posted Monday, September 1, 2008 8:43 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:56 PM
Points: 33,202, Visits: 15,348
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