Help! please - clean install of SQL Server 2019 - Error 18456 in log file

%3CLINGO-SUB%20id%3D%22lingo-sub-1404084%22%20slang%3D%22en-US%22%3EHelp!%20please%20-%20clean%20install%20of%20SQL%20Server%202019%20-%20Error%2018456%20in%20log%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1404084%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%20I%20could%20use%20some%20assistance%20understanding%20and%20clearing%20up%20an%20event%20in%20my%20log....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20the%20error%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELogin%20failed%20for%20user%20'%3CDOMAIN%20name%3D%22%22%3E%5C%3CCOMPUTER%20name%3D%22%22%3E%24'.%20Reason%3A%20Could%20not%20find%20a%20login%20matching%20the%20name%20provided.%20%5BCLIENT%3A%20%3CLOCAL%20machine%3D%22%22%3E%5D%3C%2FLOCAL%3E%3C%2FCOMPUTER%3E%3C%2FDOMAIN%3E%3C%2FP%3E%3CP%3EError%3A%2018456%2C%20Severity%3A%2014%2C%20State%3A%205.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20event%20had%20my%20domain%20name%20and%20computer%20name%20in%20there.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20seen%20a%20number%20of%20search%20results%20that%20refer%20to%20an%20issue%20with%20the%20sa%20account%20and%20I%20understand%20that.%20My%20error%20is%20referencing%20the%20server%20AD%20computer%20object.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20creating%20a%20login%20for%20that%20object%20but%20that%20did%20nothing.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20a%20clean%20install%20of%20SQL%20server%20and%20I%20have%20only%20the%20default%20instance%20created.%20Beyond%20enabling%20TCP%2FIP%20and%20Named%20Pipes%20protocols%20I%20have%20not%20done%20any%20other%20post%20install%20configuration.%20I%20wouldn't%20be%20surprised%20if%20it%20is%20just%20a%20configuration%20I%20am%20missing%20and%20could%20use%20some%20guidance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJim%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi! I could use some assistance understanding and clearing up an event in my log....

 

Here is the error:

 

Login failed for user '<domain name>\<computer name>$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]

Error: 18456, Severity: 14, State: 5.

 

The event had my domain name and computer name in there.

 

I've seen a number of search results that refer to an issue with the sa account and I understand that. My error is referencing the server AD computer object.

 

I've tried creating a login for that object but that did nothing. 

 

This is a clean install of SQL server and I have only the default instance created. Beyond enabling TCP/IP and Named Pipes protocols I have not done any other post install configuration. I wouldn't be surprised if it is just a configuration I am missing and could use some guidance.

 

Thanks,

 

Jim

0 Replies