Solved

Msg 14297 - Cannot enlist into the local machine.

Posted on 2014-01-08
7
779 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
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

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 covers how to install the Microsoft Windows Operating System (OS). What is covered in this article:  > Different Versions and Editions of the Windows OS  > Upgrading versus Fresh Installation of the OS           - Steps to take pr…
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…
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…

813 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now