SQL Server Connection Troubleshooting
When your SQL service (and/or reporting service) is using a bespoke domain user service account e.g. “sandbox\My_SQL_svc” then the Kerberos principal names have to be correct, or else AuthLite users won't be able to connect.
- Install the Microsoft SQL Configuration Manager on the sql server.
- See its "Install Instructions" on that page for how to launch it.
- When running its exe after install, make sure to launch it "run as administrator".
- Connect (leave items blank for local server)
- Go to SPNs tab. You can Fix any SPNs it identifies as wrong or missing.
- Also AuthLite is needed on the machine you're using to open the SQL tools.
- Lastly, if you are connecting to a FQDN that's a DNS alias (instead of the real server name) you need to set up SPNs for that too.