Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Msg 14297 - Cannot enlist into the local machine.

Posted on 2014-01-08
7
Medium Priority
?
873 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 1500 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
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…

876 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