Which components are necessary for SQL Server 2016/2017 to work?

This is my usual preset - https://drive.google.com/file/d/0B54HJ36TbhjwajZpTnZwbkxVYVE/view?usp=sharing

OS works great after I apply that preset and so does MS Office 2016, but it is not possible to use SQL Server 2016/2017. MS SQL Server Management Studio will not even install. I get "Exception unknown exception bla bla" error.

I would appreciate if someone could let me know what to keep to get both MS SQL Server Management Studio AND MS SQL Server 2016/2017 working without issues.
 
Any error number?

Try to keep this:

<c>activedirectory 'Active Directory'</c>
<c>adamclient 'Active Directory Lightweight Directory Services (AD LDS)'</c>
<c>azuread 'Azure Active Directory'</c>
<c>credentialmanager 'Credential Manager'</c>
<c>datacenterbridging 'Data Center Bridging (DCB)'</c>
<c>devicesync 'Microsoft Sync Framework'</c>
<c>fciclient 'File Server Resource Manager'</c>
<c>Microsoft.NET.Native.Framework.1.3 'NET.Native.Framework.1.3'</c>
<c>Microsoft.NET.Native.Runtime.1.3 'NET.Native.Runtime.1.3'</c>
<c>Microsoft.VCLibs.140.00 'VCLibs.140.00'</c>
<c>rpclocator 'Remote Procedure Call (RPC) Locator'</c>
<c>wmitools 'Windows Management Instrumentation Tools'</c>


And to make sure it would work, keep this:
<c>activedirectory 'Active Directory'</c>
<c>adamclient 'Active Directory Lightweight Directory Services (AD LDS)'</c>
<c>alg 'Application Layer Gateway Service'</c>
<c>alljoyn 'AllJoyn Router Service'</c>
<c>appid 'Application Identity Service'</c>
<c>appv 'Application Virtualization (App-V)'</c>
<c>assembly.net '.NET assembly cache'</c>
<c>autoworkplacejoin 'Workplace Join'</c>
<c>axinstall 'ActiveX Installer Service'</c>
<c>azuread 'Azure Active Directory'</c>
<c>backgroundtransfer 'Networking Background Transfer'</c>
<c>cdpsvc 'Connected Device Platform Service (CDPSvc)'</c>
<c>containers</c>
<c>credentialmanager 'Credential Manager'</c>
<c>dashost 'Device Association Service'</c>
<c>datacenterbridging 'Data Center Bridging (DCB)'</c>
<c>deliveryoptimization 'Delivery Optimization'</c>
<c>devicesflow 'Devices Flow'</c>
<c>devicesync 'Microsoft Sync Framework'</c>
<c>devquerybroker 'DevQuery Background Discovery Broker'</c>
<c>directaccess 'Direct Access Connection'</c>
<c>domainclientssvc 'IPsec Policy Agent'</c>
<c>dvdplay 'DVD Play'</c>
<c>eaphost 'Extensible Authentication Protocol (EAP)'</c>
<c>fciclient 'File Server Resource Manager'</c>
<c>fdphost 'Network Discovery'</c>
<c>ias 'Internet Authentication Service (IAS)'</c>
<c>iphelper 'Internet Protocol Helper (IP Helper)'</c>
<c>iscsi 'iSCSI Initiator'</c>
<c>isolatedusermode 'Isolated user mode'</c>
<c>kerneldebug 'Kernel Debugging'</c>
<c>killbits 'ActiveX Compatibility Flags (Killbits)'</c>
<c>location 'Location Service'</c>
<c>Microsoft.AAD.BrokerPlugin 'AAD.BrokerPlugin'</c>
<c>Microsoft.AccountsControl 'AccountsControl'</c>
<c>Microsoft.NET.Native.Framework.1.3 'NET.Native.Framework.1.3'</c>
<c>Microsoft.NET.Native.Runtime.1.3 'NET.Native.Runtime.1.3'</c>
<c>Microsoft.VCLibs.140.00 'VCLibs.140.00'</c>
<c>ncdauto 'Network Connected Devices Auto-Setup'</c>
<c>ndiscap 'NDIS Packet Capturing (NDISCAP)'</c>
<c>ndisimplat 'Network Adapter Multiplexor Protocol'</c>
<c>nettopology 'Link-Layer Topology Discovery protocol (LLTD)'</c>
<c>nfsclient 'NFS Administrative Tools'</c
<c>passport 'Microsoft Passport'</c>
<c>pimindexmaintenancesvc 'Contact Data'</c>
<c>pos 'Point of Service (POS)'</c>
<c>provisioning 'Windows Provisioning'</c>
<c>rasauto 'Remote Access Auto Connection Manager'</c>
<c>rascmak 'RAS Connection Manager Administration Kit (CMAK)'</c>
<c>rascmd 'Remote Access Service Client Tools'</c>
<c>rasmans 'Remote Access Connection Manager'</c>
<c>rdpclient 'Remote Desktop Client'</c>
<c>rdpserver 'Remote Desktop Server'</c>
<c>remoteaccessservice 'Routing and Remote Access Service'</c>
<c>remoteassistance 'Remote Assistance'</c>
<c>remotefx</c>
<c>remoteportredirector 'Remote Desktop Services Port Redirector'</c>
<c>remoteregistry 'Remote Registry'</c>
<c>rpclocator 'Remote Procedure Call (RPC) Locator'</c>
<c>simpletcp 'Simple TCP/IP services'</c>
<c>skypeortc 'Skype ORTC'</c>
<c>smbdirect 'SMB Direct (RDMA)'</c>
<c>smbserverv1 'SMB Server v1'</c>
<c>smbwitnessclientapi 'SMB Witness Client API'</c>
<c>snmp 'Simple Network Management Protocol (SNMP)'</c>
<c>telnetclient 'Telnet Client'</c>
<c>tftpclient 'TFTP client'</c>
<c>tieringengine 'Storage Tiers Management'</c>
<c>tpm 'Trusted Platform Module (TPM)'</c>
<c>uev 'User Experience Virtualization (UE-V)'</c>
<c>ui0detect 'Interactive Services Detection'</c>
<c>userdatasvc 'User Data Access'</c>
<c>userdeviceregistration 'User Device Registration'</c>
<c>winrm 'Windows Remote Management (WS-Management)'</c>
<c>wmitools 'Windows Management Instrumentation Tools'</c>
 
Last edited:
Which does mean NET is the cause of the problem. I have a whole bunch of NET Apps on my PC and they all work. It could be something entirely different. Anyway, I will check it out, probably remove component one by one until I know for sure.
 
Back
Top