none
Windows 8.1 SQL Server 2014 Enterprise Error Number: 18456

    Question

  • I didn't have this problem with the Sql 2014 Developer but not I am having issues with the Enterprise Edition giving me the following error I am using Windows 8.1:

    Server Name: GERRY
    Error Number: 18456
    Severity: 14
    State: 1
    Line Number: 65536


    ------------------------------
    Program Location:

       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
       at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
       at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
       at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData)
       at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci, IServerType server)
       at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

    Thursday, April 24, 2014 9:11 PM

Answers

All replies

  • You need to look in the SQL Server error log. There you will find the same message, but with a different state, which reveals why you cannot login. Then you can use this blog post to get more information:
    http://sqlblog.com/blogs/aaron_bertrand/archive/2011/01/14/sql-server-v-next-denali-additional-states-for-error-18456.aspx


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    Thursday, April 24, 2014 9:46 PM
  • 2014-04-24 17:19:15.09 Logon       Error: 18456, Severity: 14, State: 5.
    2014-04-24 17:19:15.09 Logon       Login failed for user 'MicrosoftAccount\Rattlerr@live.com'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]

    This is the error I get during installation:

    TITLE: Microsoft SQL Server 2014 Setup
    ------------------------------

    The following error has occurred:

    Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

    This is what I found under the Errorlog files:

    2014-04-24 18:38:16.07 spid17s     Error: 17190, Severity: 16, State: 1.
    2014-04-24 18:38:16.07 spid17s     Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0.
    2014-04-24 18:38:16.07 spid17s     Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
    2014-04-24 18:38:16.08 spid7s      Starting up database 'msdb'.
    2014-04-24 18:38:16.08 spid17s     Error: 17182, Severity: 16, State: 1.
    2014-04-24 18:38:16.08 spid17s     TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property.
    2014-04-24 18:38:16.08 spid9s      Starting up database 'mssqlsystemresource'.
    2014-04-24 18:38:16.08 spid17s     Error: 17182, Severity: 16, State: 1.
    2014-04-24 18:38:16.08 spid17s     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.
    2014-04-24 18:38:16.08 spid17s     Error: 17826, Severity: 18, State: 3.
    2014-04-24 18:38:16.08 spid17s     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.
    2014-04-24 18:38:16.08 spid17s     Error: 17120, Severity: 16, State: 1.
    2014-04-24 18:38:16.08 spid17s     SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

    Ok, now how do you fix this?



    • Edited by RattlerrFx Thursday, April 24, 2014 10:49 PM error information
    Thursday, April 24, 2014 9:55 PM
  • 2014-04-24 18:38:16.07 spid17s     Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0.
    2014-04-24 18:38:16.07 spid17s     Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.

    Hello,

    I trapped into the same error, also on Win 8.1; seems to be a common issue. See also the solve thread: http://social.msdn.microsoft.com/Forums/en-US/db3543f9-07cb-41b5-8916-84d3f09ad796/unable-to-install-sql-server-2012-developer?forum=sqlsetupandupgrade

    For me the solution worked: Uninstall the faulty instance and install it new: During engine configuration use an exiting account like "Local Services" or "Networkservice" instead of the suggested new accounts.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, April 25, 2014 6:27 AM
  • I have tried the link you suggested above but when I try to change the SQL Install Method from NT AUTHORITY/LOCAL SERVICE or NT AUTHORITY/ LOCAL ACCOUNT. It tells me it cannot be done because of some sort of network error.

    Friday, April 25, 2014 6:43 PM
  • On second thought, you should not really come that far. Windows 8.1 is not a supported operating system for Enterprise Edition. But I would expect Setup to block you at an early stage. See
    http://msdn.microsoft.com/en-us/library/ms143506%28v=sql.120%29.aspx


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    • Marked as answer by RattlerrFx Friday, April 25, 2014 10:41 PM
    Friday, April 25, 2014 9:30 PM