Solved

Msg 14297 - Cannot enlist into the local machine.

Posted on 2014-01-08
7
827 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 

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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

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…
When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
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…

623 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