MSX Server Problem: Error! - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

MSX Server Problem: Error!

Author

Topic

Gopher
Yak Posting Veteran

83 Posts

Posted - 2007-08-14 : 08:59:41

Hi All

I am trying to setup a MSX Server (Master Server) and add target servers (All of which are SQL 2005) However when I run through the wizard all seems ok but when it trys to add the target server I get the following error message below:

TITLE: Microsoft.SqlServer.Smo
------------------------------

MSX enlist failed for JobServer 'ALBANY'.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=MSX+enlist+JobServer&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The enlist operation failed (reason: SQLServerAgent Error: Unable to connect to MSX 'DALLAS'.) (Microsoft SQL Server, Error: 22026)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=22026&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Does anyone know how I get get this working?

Thanks

Gopher

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-14 : 22:27:22

What's sql agent service account on those servers?