How to set SPN?

on

After changing the SQL service account, if KERBEROS is not in use, you need to set the SPN.


#Check the SPN. Look for "IsSet" must be True
Test-DbaSpn -ComputerName $ComputerName -Credential DOMAIN\ServiceAccount
#Set SPN if "IsSet" is false
Set-DbaSpn -SPN MSSQLSvc\SQLSERVERA.domain.something -ServiceAccount domain\account

 

Comments

Post a Comment