I have a two-node SQL Server 2016 Standard Always-On environment and when I create a new availability group, I receive the error message below:
The Endpoints tab lists at least one endpoint that uses only Windows Authentication. However, the server instance might be running under a nondomain account. To use the listed endpoint, change the corresponding SQL Server service account to a domain account. To continue using the nondomain account, alter the endpoint to use a certificate.
Do you want to use the listed endpoints?
Now there is a fair amount of information to correct this, but I am struggling to find a fix for my scenario. All im finding, is when you are running SQL Server and the endpoints as a non-domain user, as the message suggests.
I am running both instances as the same domain user, which has admin on both nodes and sysadmin in each instance of SQL Server, and this can be seen on the endpoints tab, both endpoint SQL Service account entries are the
Domain\svc_account that is running SQL Server.
The Availability groups get created perfectly, i occasionally have do grant CREATE DB to the secondary node to initialize the seeding, but other than that all is great. Failovers are perfect etc. We do have over 20 AG's. Could that be an issue? I believe AG have been tested successfully at up to 100 groups. Being SQL Server Standard, we can only do 1 DB per group, and most of the DBs are small at <5GB.
So I am assuming its not causing any issues yet, but regardless I would like to know if its something I can ignore, or fix, in my scenario.
The output of Node 1:
Thank you for all your assistance.