Solved

Msg 14297 - Cannot enlist into the local machine.

Posted on 2014-01-08
7
788 Views
Last Modified: 2014-01-21
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.
0
Comment
Question by:RayManAaa
  • 4
  • 3
7 Comments
 
LVL 12

Expert Comment

by:aindelicato
ID: 39765393
MsxencryptChannelOptions in the registry of the server being enlisted must be changed from 2 to 0
0
 

Author Comment

by:RayManAaa
ID: 39765490
I already did that same results.
0
 
LVL 12

Expert Comment

by:aindelicato
ID: 39765493
Did you restart that server for the registry change to load?
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:RayManAaa
ID: 39765509
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
 
LVL 12

Accepted Solution

by:
aindelicato earned 500 total points
ID: 39765522
I don't think it needs the permission all the time, just to enlist it, you can then remove the permission.
0
 

Author Comment

by:RayManAaa
ID: 39765570
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
 

Author Closing Comment

by:RayManAaa
ID: 39797876
I never got an answer regarding what are the implications by removing the permission.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

by Nathan Brom/Bromy2004 Introduction There are numerous websites out there for any different type of program you can imagine.  Of those, you'll need to decide which ones are legitimate and aren't trying to steal your money or infect your comput…
This article describes how to set permissions to allow a limited-permissions user to start and stop a particular System Service.   It is always best to give users only the permissions that they need to perform their job, so tweaking particular permi…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question