Cannot Use The Special Principal Sa Microsoft Sql Error 15405
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and
Cannot Use The Special Principal Sa User Mapping
policies of this site About Us Learn more about Stack Overflow the cannot use the special principal 'dbo' sharepoint company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users
Cannot Drop The User 'dbo'.
Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes microsoft sql server management studio error 15405 a minute: Sign up Cannot use the special principal 'sa'. up vote 0 down vote favorite When I try to run the command EXEC master..sp_addsrvrolemember @loginame = N'sa', @rolename = N'serveradmin' GO I get the error Msg 15405, Level 11, State 1, Procedure sp_addsrvrolemember, Line 45 Cannot use the special principal 'sa'. Ideas/suggestions welcome sql sql-server-2008 share|improve this question asked Jan 7 cannot alter the user 'dbo' '13 at 1:17 ullfindsmit 531212 add a comment| 1 Answer 1 active oldest votes up vote 7 down vote accepted 'sa' is a reserved login for the sysadmin; it's already a member of the sysadmin group, which trumps all other groups. You don't need to add it to any roles, so why are you trying to do that? share|improve this answer answered Jan 7 '13 at 3:26 Stuart Ainsworth 9,5922336 1 I can give you a reason why I should modify sa => I need to run bulk insert which depends of bulkadmin ... which can't be added to sa... –HellBaby Dec 22 '14 at 8:05 members of the sysadmin role can perform any activity in the server. msdn.microsoft.com/en-us/library/ms188659.aspx –Stuart Ainsworth Dec 23 '14 at 20:08 Sorry to say this but isn't working for my 2012 SQL server version. It works just with windows logon, not with sysadmin(sa)... Maybe is just my case by this happens on 2 PC and 1 Server –HellBaby Dec 23 '14 at 22:34 That's probably because your server is conf
would find yourself with Cannot use the special principal
Login Failed For User Sa
'sa'. Microsoft SQL Server, Error: 15405 popping out when sp_changedbowner setting the sa user as the DBO of the database. To fix this, Open
Alter Authorization On Database
SQL Management Studio and Click New Query. Type: USE mydatabase
exec sp_changedbowner 'sa', 'true' Close the new query and after viewing the http://stackoverflow.com/questions/14188629/cannot-use-the-special-principal-sa security of the sa, you will find that that sa is the DBO of the database. (24093) import databasesecurity Post navigation Previous PostHow to: Clean User's Active Directory Schema from previous Lync installationNext PostFix: Cannot open your default e-mail folders in Outlook Categories Azure Cisco Exchange Hyper-V http://www.noelpulis.com/fix-cannot-use-the-special-principal-sa-microsoft-sql-server-error-15405/ Lync Server MAC Microsoft Network Office 365 OpenText eDocs Outlook Powershell Smartphones SQL Tools Uncategorized VBScript VMWare Windows Yosemite Backup Tag Cloudactive directory antispam azcopy azure backup blacklist blocklist browser cannot open cisco cloud configuration connector domain controller error esxi exchange exchange 2007 exchange 2010 firefox fix free gpo import installation lync lync deployment mailflow migration modification netlogon office 365 office 2003 outlook powershell printer pst public folders router schema sql switch timeout usb wireless device Technical help and scripts for everyday issues of a sysadmin day Recent Posts How to export mailboxes to PST in Exchange 2010 How to: Setup Import Export role in Office 365 Fix: AzCopy.exe Could not finish the operation within specified timeout Fix: Azure RemoteApp GPO login scripts not working Fix: Azure AD Connect unexpected error on sign in Proudly powered by WordPress
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » Testing Center » SQL Server Security Skills » SA Lockout Err 15405 Cannot use special... SA Lockout Err http://www.sqlservercentral.com/Forums/Topic320530-119-1.aspx 15405 Cannot use special principal SA Rate Topic Display Mode Topic Options Author Message E McNeillE McNeill Posted Saturday, November 4, 2006 8:27 PM Forum Newbie Group: General Forum Members Last Login: Monday, June 27, 2016 11:52 AM Points: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=182747 7, Visits: 26 Using sql Server 2005Everything was working fine, then I got up one morning and everything was haywire. I am working on a web site and when I try to login in I get the error message Login cannot use failed for user 'SA' because the account is currently locked out.
I went to my SQL Server and was able to log in using my windows authentication.1. My Serveris set up for Sql Server and Windows Authentication mode2. Most of the database permissions for sa were gone. When I tried to adder use SA to any database role I got the error message Cannot use the special Principal SA (Sql Server Error message 15405)3. I logged on to the server cannot use the as SA and got the same results listed above.4. I don’t have a problem any other Sql Server logins permissions in my database – it only seems to be a problem with SA.5. I have tried shutting down the server (Sql Server) and restarting it, but that didn’t fix the problem. As I said before, this all seemed to have happened overnight. I am the only one using this server right now so I can’t figure out how these changes happened.I am using the evaluation copy of Windows Server for Small business Server, Build 3790 with SP1. I have only been using it for 3 weeks so I am a long way from the end of the evaluation period, so I don’t think that is the problem.Do you have an explanation or solution for this problem? Any feedback would be appreciated. Post #320530 Greg Edwards-268690Greg Edwards-268690 Posted Monday, November 6, 2006 6:52 AM Right there with Babe Group: General Forum Members Last Login: Yesterday @ 3:59 PM Points: 790, Visits: 8,078 I assume you have an ID which has admin privileges.In SQL Server Management Studio, go to Security, then Logins.Double click on the sa account to bring up the properties sheet.On the general page, note the check boxes for Enforce password policy and Enforce password expiration. This is new for SQL 2005 - sa can be treated like a DomainSQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2008 Forums SQL Server Administration (2008) Granting role to dbo Reply to Topic Printer Friendly Author Topic Peter99 Constraint Violating Yak Guru 498 Posts Posted-02/06/2013: 12:00:14 Hi,I have one login say test and executed:use