LsaSrv Authentication error event 6037

hello,

i noticed these warnings appearing in system log:

 

the program sqlservr.exe, assigned process id 2864, not authenticate locally using target name mssqlsvc/main2.<domain_name):1433. target name used not valid. target name should refer 1 of local computer names, example, dns host name.

 

 try different target name.

 

 

i think these resulting in lot of application errors in application log. sql server setup use local system account (i know, not best practice). can see spn using authenticate using ad server's old name. had changed server name main2 main. server runs mssql, ad, dns, dhcp, etc. services. 

is there way point localsystem account use proper spn? see that mssqlsvc/main.<domain_name>:1433 defined on server, don't know how point localsystem account it.

 

thanks.

hi,

 

this issue can caused due port 1433 blocked.

 

for detailed information, please refer following microsoft kb article , technet blog:

 

clients cannot communicate sql server through port 1433 or port sql server listening on

http://support.microsoft.com/kb/293107

 

tcp/ip port numbers required communicate sql on firewall

http://support.microsoft.com/kb/287932

 

for further assistance, please submit new new question sql server forum best resource you.

 

sql server

http://social.technet.microsoft.com/forums/en-us/category/sqlserver

 

regards,

---

please remember click “mark answer” on post helps you, , click “unmark answer” if marked post not answer question. can beneficial other community members reading thread.

Windows Server  >  Management