Failed to Enlist TSX Server (SQL Server WMI provider is not available)

  • I have an MSX server SQL 2008 (10.0.5512) attempting to enlist SQL 2012 (11.0.3128) running on server 2012 as a TSX server. In the enlist wizzard the first and third steps complete without error, step two fails "SQL Server WMI provider is not available on server, invalid namespace (SystemManagement)" Both SQL Server Service and Agent accounts are domain accounts. I can connect to the SqlServer Configuration Manager. Firewall is completely off. Same subnet.

    So far I have:

    1. (Registry) MSXEncryptChannelOptions set to 0

    2. Run mofcomp against sqlmgmproviderxpsp2up.mof

    3. (Registry) Confrimed RegularMSXConnections 0

    4. SQL Server Configuration/Network Configuraton all enabled

    5. Component Services "Windows Management and Instrumentation" Launch and Activation Permissions added Everyone same as was on another SQL install server 2008. Allowed Local and Remote Launch and Activation.

    6. WMIMGMT confirmed there is an entry for Root/Microsoft/SqlServer/ComputerManagement11 and permissions match current working install on server 2008.

    I have also tried to enlist a completely serperate Server 2012 with SQL 2012 with the same results.

    Any ideas are greatly appreciated.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply