Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MsxEncryptChannelOptions and Multi-server administration Expand / Collapse
Author
Message
Posted Friday, March 1, 2013 9:30 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 8:50 AM
Points: 45, Visits: 179
Setting up the multi-server administration failed for me because the MsxEncryptChannelOptions registry value on the server I am attempting to make the target is set to '2'. According to Microsoft and everyone else on the interwebz, changing it to '0' resolves this issue.

My question is what are the effects of changing the value to '0'? Seeing as this is a production server, making changes to the registry without knowing what else it will effect kinda makes me nervous.

What else uses this registry entry or is it exclusively used by the multi-server admin functions?



"The most exciting phrase to hear in science, the one that heralds new discoveries, is not 'Eureka!' but 'That's funny...'" ~Isaac Asimov
Post #1425581
Posted Friday, March 1, 2013 1:50 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 6:23 AM
Points: 392, Visits: 405
don't mess with registry.....

===========================================
Better try and fail than not to try at all...

Database Best Practices

SQL Server Best Practices
Post #1425725
Posted Friday, April 5, 2013 4:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 9:51 AM
Points: 3, Visits: 41
I was really hesitant about modifying the registry as well, so I wrote a PowerShell Script to do it in a controlled and safe manner.

Safely Enable SQL Server Agent MultiServer Administration using PowerShell



Chrissy LeMaire, MCITP, C|EH
Blog: http://blog.netnerds.net
Twitter: @cl
Post #1439153
Posted Wednesday, November 6, 2013 10:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 6, 2013 10:55 AM
Points: 6, Visits: 12
I'm creating scripts for deployment, so it was simpler to use xp_regwrite:

EXEC master..xp_regwrite
@rootkey='HKEY_LOCAL_MACHINE',
@key='SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\SQLServerAgent',
@value_name='MsxEncryptChannelOptions',
@type='REG_SZ',
@value='00000000'

-- 0 Disables encryption between this target server and the master server. her means.
-- 1 Enables encryption only between this target server and the master server, but no certificate validation is required.
-- 2 Default. Enables full SSL encryption and certificate validation between this target server and the master server.
Post #1511961
Posted Tuesday, January 21, 2014 3:16 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 10:55 AM
Points: 23, Visits: 475
Probably worth noting that if you use the xp_regwrite version, you should go to your passive nodes in your clusters right away so you don't forget to update those as well. Otherwise upon failover, things will stop working.

Good post otherwise.



Kindest Regards,

Allen McGuire
madtownlounge.com
Post #1533381
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse