Home Forums SQL Server 2005 SQL Server 2005 General Discussion SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information RE: SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information

  • March 24, 2007 at 2:42 am

    #696747

    Installed Native client registry entries by importing the follow registry keys into the the registry. Alternatively, if you have another machine with SQL 2005 installed, export the keys and edit entries for .

    Before you import these entries, please verify if the keys exists in the registry. If they exist, your problem is something e.g. check your firewall.

    USE AT YOUR OWN RISK!!!

    Step1: Client_tree.reg

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client]

    "SharedMemoryOn"=dword:00000001

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo]

    "DSQUERY"="DBNETLIB"

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\DB-Lib]

    "AutoAnsiToOem"="ON"

    "UseIntlSettings"="ON"

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0]

    "ProtocolsSupported"=hex(7):73,00,6d,00,00,00,74,00,63,00,70,00,00,00,6e,00,70,

    00,00,00,76,00,69,00,61,00,00,00,00,00

    "ProtocolOrder"=hex(7):73,00,6d,00,00,00,74,00,63,00,70,00,00,00,6e,00,70,00,

    00,00,00,00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\GeneralFlags]

    "NumberOfFlags"=dword:00000002

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\GeneralFlags\Flag1]

    "Label"="Force protocol encryption"

    "Value"=dword:00000000

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\GeneralFlags\Flag2]

    "Label"="Trust Server Certificate"

    "Value"=dword:00000000

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\LastConnect]

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\np]

    "DLLname"="SQLNCLI"

    "NumberOfFlags"=dword:00000000

    "NumberOfProperties"=dword:00000001

    "ProtocolName"="Named Pipes"

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\np\Property1]

    "Name"="Default Pipe"

    "Value"="sql\\query"

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\sm]

    "DLLname"="SQLNCLI"

    "NumberOfFlags"=dword:00000000

    "NumberOfProperties"=dword:00000000

    "ProtocolName"="Shared Memory"

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\tcp]

    "DLLname"="SQLNCLI"

    "NumberOfFlags"=dword:00000000

    "NumberOfProperties"=dword:00000003

    "ProtocolName"="TCP/IP"

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\tcp\Property1]

    "Name"="Default Port"

    "Value"=dword:00000599

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\tcp\Property2]

    "Name"="KEEPALIVE (in milliseconds)"

    "Value"=dword:00007530

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\tcp\Property3]

    "Name"="KEEPALIVEINTERVAL (in milliseconds)"

    "Value"=dword:000003e8

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\VIA]

    "DLLname"="SQLNCLI"

    "NumberOfFlags"=dword:00000000

    "NumberOfProperties"=dword:00000002

    "ProtocolName"="VIA"

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\VIA\Property1]

    "Name"="Default Server Port"

    "Value"="0:1433"

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\VIA\Property2]

    "Name"="Default Client NIC"

    "Value"="0"

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib]

    "ProtocolOrder"=hex(7):74,00,63,00,70,00,00,00,6e,00,70,00,00,00,00,00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\LastConnect]

    ""="839057416:tcp:,1433"

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\Np]

    "DefaultPipe"="sql\\query"

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\Tcp]

    "DefaultPort"=dword:00000599

    Step 2: Tcp.reg

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp]

    "TcpDynamicPorts"=""

    "TcpHideFlag"=dword:00000000

    "TcpPort"="1433"