Post reply

Multi-server administration

  • September 1, 2008 at 7:44 am

    #123172

    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

  • September 1, 2008 at 8:43 am

    #865686

    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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply