Reputation: 68
I changed the SQL service account from NT Service\MSSQLSERVER to an AD service account. SQL server service account has administrator access in server.
But now I am unable to connect to the SQL server. Got the following message
Upvotes: 0
Views: 115
Reputation: 9
You need to check the security event logs. If you are using Kerberos then check the logon attempt with Kerberos authentication package.
Upvotes: 1