none
Problem to set up Express version RRS feed

  • Question

  • Hi,

    How to identify more reasons in Log file, to below problems?


    Many Thanks & Best Regards, Hua Min

    • Moved by Tom Phillips Wednesday, July 4, 2018 11:57 AM Installation issue
    Tuesday, July 3, 2018 8:08 AM

All replies

  • Hi!

    You can find the installation log of your SQL Server here:

     %programfiles%\MicrosoftSQL Server\<server version>\Setup Bootstrap\Log\

    Which version of SQL Server Express is it you're trying to install and on which operating system?

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    Tuesday, July 3, 2018 8:19 AM
  • Hi,

    SQL server 2014 Express, on Windows 2012 server.

    Which part of Error log file, should be shown to you?


    Many Thanks & Best Regards, Hua Min


    Tuesday, July 3, 2018 8:34 AM
  • Hi,

    What is problem to following Error Log?

    2018-07-03 00:45:43.14 Server      Microsoft SQL Server 2014 - 12.0.2000.8 (X64) 
    	Feb 20 2014 20:04:26 
    	Copyright (c) Microsoft Corporation
    	Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
    
    2018-07-03 00:45:43.14 Server      UTC adjustment: -7:00
    2018-07-03 00:45:43.14 Server      (c) Microsoft Corporation.
    2018-07-03 00:45:43.14 Server      All rights reserved.
    2018-07-03 00:45:43.14 Server      Server process ID is 4072.
    2018-07-03 00:45:43.14 Server      System Manufacturer: 'innotek GmbH', System Model: 'VirtualBox'.
    2018-07-03 00:45:43.14 Server      Authentication mode is MIXED.
    2018-07-03 00:45:43.14 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL12.SS2014EXPR\MSSQL\Log\ERRORLOG'.
    2018-07-03 00:45:43.14 Server      The service account is 'NT Service\MSSQL$SS2014EXPR'. This is an informational message; no user action is required.
    2018-07-03 00:45:43.14 Server      Registry startup parameters: 
    	 -d C:\Program Files\Microsoft SQL Server\MSSQL12.SS2014EXPR\MSSQL\DATA\master.mdf
    	 -e C:\Program Files\Microsoft SQL Server\MSSQL12.SS2014EXPR\MSSQL\Log\ERRORLOG
    	 -l C:\Program Files\Microsoft SQL Server\MSSQL12.SS2014EXPR\MSSQL\DATA\mastlog.ldf
    2018-07-03 00:45:43.14 Server      Command Line Startup Parameters:
    	 -s "SS2014EXPR"
    	 -m "SqlSetup"
    	 -Q
    	 -q "SQL_Latin1_General_CP1_CI_AS"
    	 -T 4022
    	 -T 4010
    	 -T 3659
    	 -T 3610
    	 -T 8015
    	 -d "C:\Program Files\Microsoft SQL Server\MSSQL12.SS2014EXPR\MSSQL\Template Data\master.mdf"
    	 -l "C:\Program Files\Microsoft SQL Server\MSSQL12.SS2014EXPR\MSSQL\Template Data\mastlog.ldf"
    2018-07-03 00:45:43.35 Server      SQL Server detected 1 sockets with 1 cores per socket and 1 logical processors per socket, 1 total logical processors; using 1 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
    2018-07-03 00:45:43.35 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2018-07-03 00:45:43.35 Server      Detected 2099 MB of RAM. This is an informational message; no user action is required.
    2018-07-03 00:45:43.35 Server      Using conventional memory in the memory manager.
    2018-07-03 00:45:43.37 Server      Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
    2018-07-03 00:45:43.40 Server      Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
    2018-07-03 00:45:43.40 Server      Query Store settings initialized with enabled = 1, 
    2018-07-03 00:45:43.41 Server      This instance of SQL Server last reported using a process ID of 2556 at 7/3/2018 12:45:39 AM (local) 7/3/2018 7:45:39 AM (UTC). This is an informational message only; no user action is required.
    2018-07-03 00:45:43.41 Server      Node configuration: node 0: CPU mask: 0x0000000000000001:0 Active CPU mask: 0x0000000000000001:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2018-07-03 00:45:43.41 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
    2018-07-03 00:45:43.41 Server      The maximum number of dedicated administrator connections for this instance is '1'
    2018-07-03 00:45:43.42 Server      CLR version v4.0.30319 loaded.
    2018-07-03 00:45:43.44 Server      Database Mirroring Transport is disabled in the endpoint configuration.
    2018-07-03 00:45:43.44 Server      Software Usage Metrics is disabled.
    2018-07-03 00:45:43.51 spid11s     Warning ******************
    2018-07-03 00:45:43.51 spid11s     SQL Server started in single-user mode. This an informational message only. No user action is required.
    2018-07-03 00:45:43.51 spid11s     Starting up database 'master'.
    2018-07-03 00:45:43.55 Server      Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
    2018-07-03 00:45:43.58 spid11s     3 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.
    2018-07-03 00:45:43.59 spid11s     0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.
    2018-07-03 00:45:43.59 spid11s     Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
    2018-07-03 00:45:43.73 spid11s     Service Master Key could not be decrypted using one of its encryptions. See sys.key_encryptions for details.
    2018-07-03 00:45:43.78 spid11s     SQL Server Audit is starting the audits. This is an informational message. No user action is required.
    2018-07-03 00:45:43.79 spid11s     SQL Server Audit has started the audits. This is an informational message. No user action is required.
    2018-07-03 00:45:43.80 spid11s     SQL Trace ID 1 was started by login "sa".
    2018-07-03 00:45:43.81 spid11s     Server name is 'WIN-JGOOPPEVSLU\SS2014EXPR'. This is an informational message only. No user action is required.
    2018-07-03 00:45:43.99 spid15s     A new instance of the full-text filter daemon host process has been successfully started.
    2018-07-03 00:45:44.19 spid11s     Starting up database 'msdb'.
    2018-07-03 00:45:44.19 spid12s     Starting up database 'mssqlsystemresource'.
    2018-07-03 00:45:44.28 spid12s     The resource database build version is 12.00.2000. This is an informational message only. No user action is required.
    2018-07-03 00:45:44.29 spid11s     1 transactions rolled forward in database 'msdb' (4:0). This is an informational message only. No user action is required.
    2018-07-03 00:45:44.38 spid11s     0 transactions rolled back in database 'msdb' (4:0). This is an informational message only. No user action is required.
    2018-07-03 00:45:45.05 spid12s     Starting up database 'model'.
    2018-07-03 00:45:45.33 spid12s     Clearing tempdb database.
    2018-07-03 00:45:45.69 spid12s     Starting up database 'tempdb'.
    2018-07-03 00:45:45.89 spid14s     Error: 17190, Severity: 16, State: 1.
    2018-07-03 00:45:45.89 spid14s     Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0.
    2018-07-03 00:45:46.16 spid14s     Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
    2018-07-03 00:45:46.16 spid14s     Error: 17182, Severity: 16, State: 1.
    2018-07-03 00:45:46.16 spid14s     TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property. 
    2018-07-03 00:45:46.16 spid14s     Error: 17182, Severity: 16, State: 1.
    2018-07-03 00:45:46.16 spid14s     TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property. 
    2018-07-03 00:45:46.16 spid14s     Error: 17826, Severity: 18, State: 3.
    2018-07-03 00:45:46.16 spid14s     Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
    2018-07-03 00:45:46.16 spid14s     Error: 17120, Severity: 16, State: 1.
    2018-07-03 00:45:46.16 spid14s     SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
    


    Many Thanks & Best Regards, Hua Min

    Tuesday, July 3, 2018 1:02 PM
  • SQL Server is not able to create a self-signed certificate. This can sometimes be due to that your default profile in Windows is corrupted, although I seem to recall different error codes for that case.

    To make it clear, Setup creates this new user, NT Service\MSSQL$SS2014EXPR, and its profile is created from the default profile.

    I had this problem sometime ago. I believe that my resolution was to copy the default problem from another machine running the same version of Windows.
    It seems that happens on a virtual machine running VirtualBox. Maybe the easiest is to flatten the VM and start over?

    Tuesday, July 3, 2018 9:58 PM

  • 2018-07-03 00:45:45.89 spid14s     Error: 17190, Severity: 16, State: 1.
    2018-07-03 00:45:45.89 spid14s     Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0.
    2018-07-03 00:45:46.16 spid14s     Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
    2018-07-03 00:45:46.16 spid14s     Error: 17182, Severity: 16, State: 1.
    2018-07-03 00:45:46.16 spid14s     TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property. 
    2018-07-03 00:45:46.16 spid14s     Error: 17182, Severity: 16, State: 1.
    2018-07-03 00:45:46.16 spid14s     TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property. 
    2018-07-03 00:45:46.16 spid14s     Error: 17826, Severity: 18, State: 3.
    2018-07-03 00:45:46.16 spid14s     Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
    2018-07-03 00:45:46.16 spid14s     Error: 17120, Severity: 16, State: 1.
    2018-07-03 00:45:46.16 spid14s     SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

    Hi HuaMin,

    According to your error log, it seems like that your issue is related to above part. 

    For these errors, please refer to following articles, see if they work for you:

    https://www.beejblog.com/2012/02/sql-server-solved-unable-to-initialize.html

    https://blog.sqlauthority.com/2017/11/09/sql-server-startup-error-17190-severity-16-initializing-fallback-certificate-failed-error-code-1-state-20/ 

    Thanks,
    Xi Jin.


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, July 4, 2018 2:55 AM
    Moderator
  • Thanks to all.

    Erland,

    Is there clear way to avoid issue, in Virtual Box. I did do the update in VBox but there is still problem below.

    2018-07-03 23:08:58.55 Server      Microsoft SQL Server 2012 (SP3) (KB3072779) - 11.0.6020.0 (X64) 
    	Oct 20 2015 15:36:27 
    	Copyright (c) Microsoft Corporation
    	Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
    
    2018-07-03 23:08:58.55 Server      (c) Microsoft Corporation.
    2018-07-03 23:08:58.55 Server      All rights reserved.
    2018-07-03 23:08:58.55 Server      Server process ID is 1868.
    2018-07-03 23:08:58.55 Server      System Manufacturer: 'innotek GmbH', System Model: 'VirtualBox'.
    2018-07-03 23:08:58.55 Server      Authentication mode is MIXED.
    2018-07-03 23:08:58.55 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL11.SS2012EXPR\MSSQL\Log\ERRORLOG'.
    2018-07-03 23:08:58.55 Server      The service account is 'NT Service\MSSQL$SS2012EXPR'. This is an informational message; no user action is required.
    2018-07-03 23:08:58.55 Server      Registry startup parameters: 
    	 -d C:\Program Files\Microsoft SQL Server\MSSQL11.SS2012EXPR\MSSQL\DATA\master.mdf
    	 -e C:\Program Files\Microsoft SQL Server\MSSQL11.SS2012EXPR\MSSQL\Log\ERRORLOG
    	 -l C:\Program Files\Microsoft SQL Server\MSSQL11.SS2012EXPR\MSSQL\DATA\mastlog.ldf
    2018-07-03 23:08:58.55 Server      Command Line Startup Parameters:
    	 -s "SS2012EXPR"
    	 -m "SqlSetup"
    	 -Q
    	 -q "SQL_Latin1_General_CP1_CI_AS"
    	 -T 4022
    	 -T 4010
    	 -T 3659
    	 -T 3610
    	 -T 8015
    	 -T 902
    	 -d "C:\Program Files\Microsoft SQL Server\MSSQL11.SS2012EXPR\MSSQL\Template Data\master.mdf"
    	 -l "C:\Program Files\Microsoft SQL Server\MSSQL11.SS2012EXPR\MSSQL\Template Data\mastlog.ldf"
    2018-07-03 23:08:58.63 Server      SQL Server detected 1 sockets with 1 cores per socket and 1 logical processors per socket, 1 total logical processors; using 1 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
    2018-07-03 23:08:58.63 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2018-07-03 23:08:58.63 Server      Detected 2099 MB of RAM. This is an informational message; no user action is required.
    2018-07-03 23:08:58.63 Server      Using conventional memory in the memory manager.
    2018-07-03 23:08:58.68 Server      Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
    2018-07-03 23:08:58.69 Server      This instance of SQL Server last reported using a process ID of 1840 at 7/3/2018 11:08:53 PM (local) 7/4/2018 6:08:53 AM (UTC). This is an informational message only; no user action is required.
    2018-07-03 23:08:58.69 Server      Node configuration: node 0: CPU mask: 0x0000000000000001:0 Active CPU mask: 0x0000000000000001:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2018-07-03 23:08:58.69 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
    2018-07-03 23:08:58.70 Server      CLR version v4.0.30319 loaded.
    2018-07-03 23:08:58.72 Server      Database Mirroring Transport is disabled in the endpoint configuration.
    2018-07-03 23:08:58.72 Server      Software Usage Metrics is disabled.
    2018-07-03 23:08:58.79 Server      Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
    2018-07-03 23:08:58.79 spid8s      Warning ******************
    2018-07-03 23:08:58.79 spid8s      SQL Server started in single-user mode. This an informational message only. No user action is required.
    2018-07-03 23:08:58.80 spid8s      Starting up database 'master'.
    2018-07-03 23:08:58.86 spid8s      9 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.
    2018-07-03 23:08:58.89 spid8s      0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.
    2018-07-03 23:08:58.89 spid8s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
    2018-07-03 23:09:01.03 spid8s      Service Master Key could not be decrypted using one of its encryptions. See sys.key_encryptions for details.
    2018-07-03 23:09:01.03 spid8s      An error occurred during Service Master Key initialization. SQLErrorCode=x_cse_CannotEncryptSMK, State=2, LastWindowsError=-2146892987.
    2018-07-03 23:09:01.17 spid8s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.
    2018-07-03 23:09:01.17 spid8s      SQL Server Audit has started the audits. This is an informational message. No user action is required.
    2018-07-03 23:09:01.31 spid8s      SQL Trace ID 1 was started by login "sa".
    2018-07-03 23:09:01.37 spid8s      Server name is 'WIN-JGOOPPEVSLU\SS2012EXPR'. This is an informational message only. No user action is required.
    2018-07-03 23:09:01.62 spid12s     A new instance of the full-text filter daemon host process has been successfully started.
    2018-07-03 23:09:01.64 spid8s      Starting up database 'msdb'.
    2018-07-03 23:09:01.64 spid9s      Starting up database 'mssqlsystemresource'.
    2018-07-03 23:09:01.69 spid9s      The resource database build version is 11.00.6020. This is an informational message only. No user action is required.
    2018-07-03 23:09:01.78 spid8s      1 transactions rolled forward in database 'msdb' (4:0). This is an informational message only. No user action is required.
    2018-07-03 23:09:01.86 spid8s      0 transactions rolled back in database 'msdb' (4:0). This is an informational message only. No user action is required.
    2018-07-03 23:09:02.12 spid9s      Starting up database 'model'.
    2018-07-03 23:09:02.28 spid9s      Clearing tempdb database.
    2018-07-03 23:09:02.68 spid9s      Starting up database 'tempdb'.
    2018-07-03 23:09:03.49 spid11s     Error: 17190, Severity: 16, State: 1.
    2018-07-03 23:09:03.49 spid11s     Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0.
    2018-07-03 23:09:03.49 spid11s     Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
    2018-07-03 23:09:03.49 spid11s     Error: 17182, Severity: 16, State: 1.
    2018-07-03 23:09:03.49 spid11s     TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property. 
    2018-07-03 23:09:03.49 spid11s     Error: 17182, Severity: 16, State: 1.
    2018-07-03 23:09:03.49 spid11s     TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property. 
    2018-07-03 23:09:03.49 spid11s     Error: 17826, Severity: 18, State: 3.
    2018-07-03 23:09:03.49 spid11s     Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
    2018-07-03 23:09:03.49 spid11s     Error: 17120, Severity: 16, State: 1.
    2018-07-03 23:09:03.49 spid11s     SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
    


    Many Thanks & Best Regards, Hua Min

    Wednesday, July 4, 2018 6:52 AM
  • Erland,

    What is the problem to this? I did encounter the same problem, after having reinstalled Windows server. Here is the log

    2018-07-05 21:46:02.49 Server      Microsoft SQL Server 2012 (SP3) (KB3072779) - 11.0.6020.0 (X64) 
    	Oct 20 2015 15:36:27 
    	Copyright (c) Microsoft Corporation
    	Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
    
    2018-07-05 21:46:02.49 Server      (c) Microsoft Corporation.
    2018-07-05 21:46:02.49 Server      All rights reserved.
    2018-07-05 21:46:02.49 Server      Server process ID is 1188.
    2018-07-05 21:46:02.49 Server      System Manufacturer: 'innotek GmbH', System Model: 'VirtualBox'.
    2018-07-05 21:46:02.49 Server      Authentication mode is MIXED.
    2018-07-05 21:46:02.49 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL11.SS2012EXPR\MSSQL\Log\ERRORLOG'.
    2018-07-05 21:46:02.49 Server      The service account is 'NT Service\MSSQL$SS2012EXPR'. This is an informational message; no user action is required.
    2018-07-05 21:46:02.49 Server      Registry startup parameters: 
    	 -d C:\Program Files\Microsoft SQL Server\MSSQL11.SS2012EXPR\MSSQL\DATA\master.mdf
    	 -e C:\Program Files\Microsoft SQL Server\MSSQL11.SS2012EXPR\MSSQL\Log\ERRORLOG
    	 -l C:\Program Files\Microsoft SQL Server\MSSQL11.SS2012EXPR\MSSQL\DATA\mastlog.ldf
    2018-07-05 21:46:02.49 Server      Command Line Startup Parameters:
    	 -s "SS2012EXPR"
    	 -m "SqlSetup"
    	 -Q
    	 -q "SQL_Latin1_General_CP1_CI_AS"
    	 -T 4022
    	 -T 4010
    	 -T 3659
    	 -T 3610
    	 -T 8015
    	 -T 902
    	 -d "C:\Program Files\Microsoft SQL Server\MSSQL11.SS2012EXPR\MSSQL\Template Data\master.mdf"
    	 -l "C:\Program Files\Microsoft SQL Server\MSSQL11.SS2012EXPR\MSSQL\Template Data\mastlog.ldf"
    2018-07-05 21:46:02.60 Server      SQL Server detected 1 sockets with 1 cores per socket and 1 logical processors per socket, 1 total logical processors; using 1 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
    2018-07-05 21:46:02.60 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2018-07-05 21:46:02.60 Server      Detected 2047 MB of RAM. This is an informational message; no user action is required.
    2018-07-05 21:46:02.60 Server      Using conventional memory in the memory manager.
    2018-07-05 21:46:02.64 Server      Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
    2018-07-05 21:46:02.65 Server      This instance of SQL Server last reported using a process ID of 3884 at 7/5/2018 9:45:57 PM (local) 7/6/2018 4:45:57 AM (UTC). This is an informational message only; no user action is required.
    2018-07-05 21:46:02.65 Server      Node configuration: node 0: CPU mask: 0x0000000000000001:0 Active CPU mask: 0x0000000000000001:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2018-07-05 21:46:02.66 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
    2018-07-05 21:46:02.66 Server      CLR version v4.0.30319 loaded.
    2018-07-05 21:46:02.68 Server      Database Mirroring Transport is disabled in the endpoint configuration.
    2018-07-05 21:46:02.68 Server      Software Usage Metrics is disabled.
    2018-07-05 21:46:02.69 Server      Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
    2018-07-05 21:46:02.69 spid8s      Warning ******************
    2018-07-05 21:46:02.70 spid8s      SQL Server started in single-user mode. This an informational message only. No user action is required.
    2018-07-05 21:46:02.70 spid8s      Starting up database 'master'.
    2018-07-05 21:46:02.76 spid8s      11 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.
    2018-07-05 21:46:02.79 spid8s      0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.
    2018-07-05 21:46:02.79 spid8s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
    2018-07-05 21:46:04.86 spid8s      Service Master Key could not be decrypted using one of its encryptions. See sys.key_encryptions for details.
    2018-07-05 21:46:04.86 spid8s      An error occurred during Service Master Key initialization. SQLErrorCode=x_cse_CannotEncryptSMK, State=2, LastWindowsError=-2146892987.
    2018-07-05 21:46:04.93 spid8s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.
    2018-07-05 21:46:04.93 spid8s      SQL Server Audit has started the audits. This is an informational message. No user action is required.
    2018-07-05 21:46:04.94 spid8s      SQL Trace ID 1 was started by login "sa".
    2018-07-05 21:46:04.94 spid8s      Server name is 'WIN-IVH7S9CM3BP\SS2012EXPR'. This is an informational message only. No user action is required.
    2018-07-05 21:46:05.10 spid12s     A new instance of the full-text filter daemon host process has been successfully started.
    2018-07-05 21:46:05.11 spid8s      Starting up database 'msdb'.
    2018-07-05 21:46:05.11 spid9s      Starting up database 'mssqlsystemresource'.
    2018-07-05 21:46:05.14 spid9s      The resource database build version is 11.00.6020. This is an informational message only. No user action is required.
    2018-07-05 21:46:05.16 spid8s      1 transactions rolled forward in database 'msdb' (4:0). This is an informational message only. No user action is required.
    2018-07-05 21:46:05.17 spid8s      0 transactions rolled back in database 'msdb' (4:0). This is an informational message only. No user action is required.
    2018-07-05 21:46:05.28 spid9s      Starting up database 'model'.
    2018-07-05 21:46:05.39 spid9s      Clearing tempdb database.
    2018-07-05 21:46:05.48 spid9s      Starting up database 'tempdb'.
    2018-07-05 21:46:07.00 spid11s     Error: 17190, Severity: 16, State: 1.
    2018-07-05 21:46:07.00 spid11s     Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0.
    2018-07-05 21:46:07.00 spid11s     Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
    2018-07-05 21:46:07.00 spid11s     Error: 17182, Severity: 16, State: 1.
    2018-07-05 21:46:07.00 spid11s     TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property. 
    2018-07-05 21:46:07.00 spid11s     Error: 17182, Severity: 16, State: 1.
    2018-07-05 21:46:07.00 spid11s     TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property. 
    2018-07-05 21:46:07.00 spid11s     Error: 17826, Severity: 18, State: 3.
    2018-07-05 21:46:07.00 spid11s     Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
    2018-07-05 21:46:07.00 spid11s     Error: 17120, Severity: 16, State: 1.
    2018-07-05 21:46:07.00 spid11s     SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
    


    Many Thanks & Best Regards, Hua Min

    Friday, July 6, 2018 6:27 AM
  • Unfortunately, I have no idea what the problem might be. It's sad to hear that a Windows reinstall did not help.

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    Friday, July 6, 2018 8:51 AM
  • Hi,

    Any other help to this?


    Many Thanks & Best Regards, Hua Min

    Saturday, July 7, 2018 5:39 AM
  • Thanks to all.

    Erland,

    This problem is not only happening in VBox but also in other kinds of Virtual machine. Can this be related to Windows update?


    Many Thanks & Best Regards, Hua Min

    Monday, July 9, 2018 1:18 PM
  • This problem is not only happening in VBox but also in other kinds of Virtual machine. Can this be related to Windows update?

    That sounds bad.

    But are all these machines in the same corporation with the same antivirus etc?

    How are you installing Windows? An image you got from MSDN? Or something your IT deparment gave you?

    Have you tried Windows 2012 only, or also other versions of Windows?


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    Monday, July 9, 2018 9:49 PM