//
you're reading...
Database, IT-Center, SQL Server

Cannot use the special principal ‘sa’ (Error: 15405) MsSQL Server

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.

also see : http://www.techurbia.com/2009/03/cannot-set-a-credential-for-principal-sa-sql-server-20052008.html

About berbagisolusi

Berbagi merupakan sebuah bentuk simbol keikhlasan untuk membantu dan menolong, sedangkan solusi adalah cara menyelesaikan masalah. Setiap manusia pasti mengalami masalah, tetapi kita tidak perlu mengalami masalah yang sama jika orang lain pernah mengalami dan kita tahu hal tersebut.

Discussion

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 9 other followers

December 2011
M T W T F S S
« Nov   Jan »
 1234
567891011
12131415161718
19202122232425
262728293031  

Archives

Web Statistic

Blog Stats

  • 149,551 hits
%d bloggers like this: