Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405
ERROR: Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405
SOLUTION: run this command in the query editor window for each database
exec sp_changedbowner 'sa','true'
I Have this issue running SQL Server 2008 and this message was in the log:
“Login failed for user ‘CENTRAL\operacao’. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors”
I could not use any other login except by the login that was used to install SQL Server. So the solution was:
1) Login in the server with the same account used to setup SQL Sever.
2) Run — GRANT CONTROL SERVER TO “my login” for each user that you want to grant rights in the server.
This worked for me.
USE [master] GO ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[LIFTest], DEFAULT_LANGUAGE=[us_english] , CHECK_EXPIRATION=OFF, CHECK_POLICY=(ON/OFF), NO CREDENTIAL GO USE [master] GO ALTER LOGIN [sa] WITH PASSWORD=N'JH@46O!IH#NFi349gh' GO
You can fix using GUI tools, please login at MSSQL Management Studio,
1. Login using Windows Auth
2. Properties at connection
3. Click Security at Righ Menu, and find
a .SQLServer And Windows Auth,
b. It’s weird how “Map to Credential” is checked yet there is no credential specified. But that’s what you have to do.