Apple Canyon Lake. Apple Canyon Lake is a private recreation community with a beautiful 9-hole golf course and lakeside restaurant, in the heart of scenic Jo Daviess County, just minutes from historic Galena, Elizabeth, Scales Mound, and Stockton.
As a best practice, SQL Server Agent service account rights should be kept as low as possible to prevent exposing your system to security risks. Making the SQL Server service account an administrator, at either a server level or a domain level, grants too many unneeded privileges and should never be done.
If we change this over to a Domain User Account for the SQL Service account, things change a little. By default a Domain User does not have the permission required to create the SPN. So, when you start SQL Server with a Domain User Account, you will see an entry in your ERRORLOG similar to the following: