Skip to content

SQL Server DBA - Dedicated Blog for all DBA and Developers

SQL DBA blog is dedicated in providing the highest quality and most in-depth SQL Server material to boost your career or to make one more productive.
  • Home
  • SQL Admin
    • SQL Development
    • SQL Server Basics
      • SQL Server Architecture
      • SQL Server Management Studio
      • SQL Server Configuration Manager
    • Using Query Analyser
    • Adding SQL Agent Job
    • Backing up SQL Server Database
    • Restoring Database in SQL Server
    • SQL Server Activity Monitor
    • Using SQL Server Database Tuning Advisor
    • Using SQL Server Profiler
    • SQL Server RPO and RTO
    • SQL Server 2008 HA and DR Solutions
    • SQL Server Encryption
  • High Availability
    • Failover Clustering
    • Database Mirroring
    • Replication
      • Transactional Replication
      • Snapshot Replication
      • Merge Replication
    • Disaster Recovery
      • Backup and Restore
      • Log Shipping
      • Database Mirroring
  • Performance Tuning
    • Operating System Memory Counters
      • OS Memory and Paging Performance Counters
      • OS CPU and Processor Counters
      • OS Disk and Miscellaneous Counters
    • SQL Server Memory
      • Buffer Manager & Memory Performance Counters
      • SQL Server: Memory Manager Counters
      • My Memory Usage– Performance Counters
    • Other Important Performance Counters
      • Data Access Performance Counters
      • User Database Performance Counters
      • SQL Server SQL Statistics Counters
      • Workload Performance Counters
      • Important Perfmon Counters %Processor and Disk monitoring counters
      • SQL Server : Plan Cache Counters
    • Users & Locks Performance Counters
    • Getting Perfmon data from inside of SSMS
  • BI Tools
    • Administration of Reporting Services
    • Administration of Analysis Services
    • Scheduling Integration Services Package
  • Contact Us

SQL Server DBA - Dedicated Blog for all DBA and Developers

SQL DBA blog is dedicated in providing the highest quality and most in-depth SQL Server material to boost your career or to make one more productive.
  • Home
  • SQL Admin
    • SQL Development
    • SQL Server Basics
      • SQL Server Architecture
      • SQL Server Management Studio
      • SQL Server Configuration Manager
    • Using Query Analyser
    • Adding SQL Agent Job
    • Backing up SQL Server Database
    • Restoring Database in SQL Server
    • SQL Server Activity Monitor
    • Using SQL Server Database Tuning Advisor
    • Using SQL Server Profiler
    • SQL Server RPO and RTO
    • SQL Server 2008 HA and DR Solutions
    • SQL Server Encryption
  • High Availability
    • Failover Clustering
    • Database Mirroring
    • Replication
      • Transactional Replication
      • Snapshot Replication
      • Merge Replication
    • Disaster Recovery
      • Backup and Restore
      • Log Shipping
      • Database Mirroring
  • Performance Tuning
    • Operating System Memory Counters
      • OS Memory and Paging Performance Counters
      • OS CPU and Processor Counters
      • OS Disk and Miscellaneous Counters
    • SQL Server Memory
      • Buffer Manager & Memory Performance Counters
      • SQL Server: Memory Manager Counters
      • My Memory Usage– Performance Counters
    • Other Important Performance Counters
      • Data Access Performance Counters
      • User Database Performance Counters
      • SQL Server SQL Statistics Counters
      • Workload Performance Counters
      • Important Perfmon Counters %Processor and Disk monitoring counters
      • SQL Server : Plan Cache Counters
    • Users & Locks Performance Counters
    • Getting Perfmon data from inside of SSMS
  • BI Tools
    • Administration of Reporting Services
    • Administration of Analysis Services
    • Scheduling Integration Services Package
  • Contact Us
Home » SQL Server Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405

SQL Server Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405

  • Vamshi B Vamshi B
  • March 5, 2020
  • SQL Server, SQL Server Errors

Table of Contents

  • Cause of Error in SQL Server ” Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405 “
  • To Fix this Error in SQL Server ” Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405 “
  • Another Cause of Error in SQL Server ” Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405 “
  • Another Fix this Error in SQL Server ” Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405 “

Cause of Error in SQL Server ” Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405 “

when importing a database in your SQL instance you would find yourself with Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405 popping out when setting the sa user as the DBO of the database.

To Fix this Error in SQL Server ” Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405 “

Open SQL Management Studio and Click New Query. Type:

USE mydatabase
exec sp_changedbowner ‘sa’, ‘true’

To change the owner of the database, you can use sp_changedbowner or ALTER AUTHORIZATION command

Another Cause of Error in SQL Server ” Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405 “

“Login failed for user ‘testdomain\test’. 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.

Another Fix this Error in SQL Server ” Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405 “

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.

USE [master]
GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[Test], DEFAULT_LANGUAGE=[us_english]
, CHECK_EXPIRATION=OFF, CHECK_POLICY=(ON/OFF), NO CREDENTIAL
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N’Strongpassword’
GO

In SSMS GUI

1. Login using Windows Authentication
2. Properties at connection
3. Click Security at Right Menu, and find
a SQL Server And Windows Authentication,
b. Make sure “Map to Credential” is checked

Tags:cannot use the special principal 'sa' sql server 2014login failed for user 'sa'sp_changedbownersql error 15150sql error 15405 cannot use the special principal 'sa'sql error number 15405sql server authentication login failedsql server error 18456what is sql server error 15405

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • Backup and Restore
  • Concurrency Control
  • Connectivity Issues
  • CTE
  • Database Mail
  • Database Maintenance
  • Database Mirrroring
  • Dealocks
  • Disaster Recovery
  • Disk I/O
  • Error Log
  • Extended Events
  • FTP
  • High Availability
  • In-Memory OLTP
  • Indexes
  • Log Shipping
  • MDW
  • Memory Configurations
  • New Features
  • Performance issues
  • Performance Tuning
  • Plan Cache
  • Policy Based Management
  • PRINCE2
  • Project Management
  • Replication
  • Reporting Services
  • Resource Database
  • Resource Governor
  • Revolution Analytics
  • rto rpo
  • SQL Server
  • SQL Server Admin
  • SQL Server Administration
  • SQL Server Alerts and Notifications
  • SQL Server Architecture
  • SQL Server Errors
  • SQL Server Extended Events
  • SQL Server Indexes
  • SQL Server Locks
  • SQL Server on Linux
  • SQL Server Security
  • SSRS
  • Storage Internals
  • Stored Procedures
  • System Databases
  • Table Variable
  • TDE
  • Temporary Database
  • Temporary Tables
  • Temporary Variables
  • Transaction Log
  • Transaction Log Shipping
  • Transactional Replication
  • TSQL
  • Uncategorized
  • Wait Stats

Please follow & like us :)

RSS
Follow by Email
Facebook
fb-share-icon

My Cool Posts…

  • SQL Server Error : 10033, Severity: 16. The specified index does not exist or th
  • SQL Server Error : 10032, Severity: 16. Cannot return multiple result sets (not
  • SQL Server Error : 16389, Communication link failure
  • SQL Server Error : 1003, Severity: 15. Line %d: %ls clause allowed only for %ls
  • SQL Server Error : 10035, Severity: 16. No value was given for one or more of th
  • SQL Server Error : 10034, Severity: 16. The specified table or view does not exi
  • SQL Server Error : 16943, Severity: 16. Could not complete cursor operation beca
  • SQL Server Error : 16915, Severity: 16. A cursor with the name ‘%.*ls’ already e
  • SQL Server Error : 1639 The eror occurs during installation of SQL Server
  • SQL Server Error : 15404, Severity: 16. Could not obtain information about Windo

DBA

SQL Server DBA

Google site link is https://sites.google.com/view/sqlserver-dba

For list of all URL's https://docs.google.com/spreadsheets/d/1Pmt8rt4TOvvf8IXjudtqz_c-sLQQilRALQStYyVMK3I/edit?usp=sharing

Twitter Account is https://twitter.com/VamshidharBokka

Facebook page is www.facebook.com/SQLServerDBABlog

SQLServerDBA | Copyright by SQLServerDBA

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept All”, you consent to the use of ALL the cookies. However, you may visit "Cookie Settings" to provide a controlled consent.
Cookie SettingsAccept All
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT