March 30, 2015 at 9:52 pm
Hey all,
Attempting to setup MSA (trial run for looking at options for job sync with an always on deployment) and getting the following error when finishing the wizard. Unfortunately so far I haven't had much luck in finding more information on, that and it's midnight ... ready to call it a night for now!
Any thoughts?
Thanks
TITLE: Microsoft.SqlServer.Smo
------------------------------
MSX enlist failed for JobServer 'SQL01\AO1'.
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.0.2000.8+((SQL14_RTM).140220-1752)&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)
------------------------------
Cannot enlist into the local machine. (Microsoft SQL Server, Error: 14297)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=12.00.2000&EvtSrc=MSSQLServer&EvtID=14297&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Here's the output of the report:
Enlist TSX Progress
- Create MSXOperator (Success)
Checking for an existing MSXOperator.
Updating existing MSXOperator.
Successfully updated MSXOperator.
- Make sure the Agent service for 'SQL01\AO1' is running (Success)
The service 'SQLAgent$AO1' is running.
- Ensure the agent startup account for 'SQL01\AO1' has rights to login as a target server (Success)
Checking to see if the startup account for 'SQL01\AO1' already exists.
Login exists on server.
Checking to see if login has rights to msdb.
Login has rights to msdb.
Checking to see if user is a member of the TargetServersRole.
User is a member of the TargetServersRole.
- Enlist 'SQL01\AO1' into 'SQL01\AO1' (Error)
Enlisting target server 'SQL01\AO1' with master server 'SQL01\AO1'.
Using new enlistment method.
Messages
MSX enlist failed for JobServer 'SQL01\AO1'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.0.2000.8+((SQL14_RTM).140220-1752)&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)
------------------------------
Cannot enlist into the local machine. (Microsoft SQL Server, Error: 14297)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=12.00.2000&EvtSrc=MSSQLServer&EvtID=14297&LinkId=20476
- Ensure the agent startup account for 'SQL02\AO2' has rights to login as a target server (Success)
Checking to see if the startup account for 'SQL02\AO2' already exists.
Login exists on server.
Checking to see if login has rights to msdb.
Login has rights to msdb.
Checking to see if user is a member of the TargetServersRole.
User is a member of the TargetServersRole.
- Enlist 'SQL02\AO2' into 'SQL01\AO1' (Error)
Enlisting target server 'SQL02\AO2' with master server 'SQL01\AO1'.
Using new enlistment method.
Messages
MSX enlist failed for JobServer 'SQL02\AO2'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.0.2000.8+((SQL14_RTM).140220-1752)&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 'SQL01\AO1'.) (Microsoft SQL Server, Error: 22026)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=12.00.2000&EvtSrc=MSSQLServer&EvtID=22026&LinkId=20476
- Ensure the agent startup account for 'SQL03\AO3' has rights to login as a target server (Success)
Checking to see if the startup account for 'SQL03\AO3' already exists.
Login exists on server.
Checking to see if login has rights to msdb.
Login has rights to msdb.
Checking to see if user is a member of the TargetServersRole.
User is a member of the TargetServersRole.
- Enlist 'SQL03\AO3' into 'SQL01\AO1' (Error)
Enlisting target server 'SQL03\AO3' with master server 'SQL01\AO1'.
Using new enlistment method.
Messages
MSX enlist failed for JobServer 'SQL03\AO3'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.0.2000.8+((SQL14_RTM).140220-1752)&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 'SQL01\AO1'.) (Microsoft SQL Server, Error: 22026)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=12.00.2000&EvtSrc=MSSQLServer&EvtID=22026&LinkId=20476
March 31, 2015 at 2:29 am
check the following link might help if the issue is related to certificate/encryption:
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply