Msg 14297 - Cannot enlist into the local machine.

I am trying to create a new MSX server and enlist a SQL server (TSX) to the master.  However I am running into a problem, I am getting the following error message.

Msg 14297 - Cannot enlist into the local machine.
RayManAaaAsked:
Who is Participating?
 
aindelicatoConnect With a Mentor Commented:
I don't think it needs the permission all the time, just to enlist it, you can then remove the permission.
0
 
aindelicatoCommented:
MsxencryptChannelOptions in the registry of the server being enlisted must be changed from 2 to 0
0
 
RayManAaaAuthor Commented:
I already did that same results.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
aindelicatoCommented:
Did you restart that server for the registry change to load?
0
 
RayManAaaAuthor Commented:
OK, I think I made some progress, I am getting a new error.

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

MSX enlist failed for JobServer 'SQLSERVER'.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.3373.0+((SQL11_SP1_QFE-CU).130629-2102+)&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)

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

Only members of the sysadmin role can execute this stored procedure. (Microsoft SQL Server, Error: 15003)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.3381&EvtSrc=MSSQLServer&EvtID=15003&LinkId=20476

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

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


I can resolve this problem by giving the account in question the sysadmin role.  However what if I don't want to give it sysadmin for security reasons.  Can I assign the specific stored procedures that it needs instead?
0
 
RayManAaaAuthor Commented:
Yes, that works!

However, since I am doing this for the first time I am not sure what I am loosing.  Would you know what functionality I can be giving up by doing this?
0
 
RayManAaaAuthor Commented:
I never got an answer regarding what are the implications by removing the permission.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.