Error 15405 Cannot Use The Special Principal
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company cannot use the special principal sa microsoft sql error 15405 Business Learn more about hiring developers or posting ads with us Stack Overflow Questions cannot use the special principal sa user mapping Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers,
Cannot Use The Special Principal 'dbo' Sharepoint
just like you, helping each other. Join them; it only takes 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
Cannot Drop The User 'dbo'.
@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 '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 cannot alter the user 'dbo' 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 configured to use Windows authentication only, not mixed mode. Try this: SELECT CASE SERVERPROPERTY('IsIntegratedSecurityOnly') WHEN 1 THEN 'Windows Authentication' WHEN 0 THEN 'Windows and SQL Server Authentication' END as [Authentication Mode] –Stuart Ainsworth Dec 25 '14 at 0:51 It's Windows and SQL Server Authentication according the result as I know already. –HellBaby Dec 26 '14 at 13:30 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign u
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) Home20122008 R2200820052000LibraryForums Ask a question Quick access Forums home Browse forums users FAQ
Sp_changedbowner
Search related threads Remove From My Forums Answered login failed for user sa by: Cannot use the special principle 'sa' SQL Server > SQL Server Security alter authorization on database Question 0 Sign in to vote Ok, here's my issue... SQL 2005. I have about 12 different databases, which about http://stackoverflow.com/questions/14188629/cannot-use-the-special-principal-sa 4 of them are have no user mapped to it. Under the SA login, databases are mapped to the "dbo". The 4 I am having issues with have no user mapped. They are blank. Here is where I am at... Security>Logins>sa>Login https://social.technet.microsoft.com/Forums/sqlserver/en-US/d5ff5f16-4b79-4405-be42-27d37f2eb67f/cannot-use-the-special-principle-sa?forum=sqlsecurity Properties>User Mapping The columns are "Map", "Database", "User", and "Default Schema" Here is an example of the correct Selection Map=checked, Database=eDistribution, User=dbo, Default Schema=dbo Now here is an example of a problem database Map=unchecked, Database=FORMS, User=blank, Default Schema=blank Here is the error when trying to add the "dbo" as a user Any ideas? TITLE: Microsoft SQL Server Management Studio------------------------------ Create failed for User 'sa'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+User&LinkId=20476 ------------------------------ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Cannot use the special principal 'sa'. (Microsoft SQL Server, Error: 15405) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1406&EvtSrc=MSSQLServer&EvtID=15405&LinkId=20476 ------------------------------BUTTONS: OK------------------------------ TITLE: Microsoft SQL Server Management Studio------------------------------ Create failed for User 'dbo'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+User&
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: 'sa' User Map error SQL Server > SQL Server https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c2dc1237-5a33-48f8-9c11-e2c51424b198/sa-user-map-error?forum=sqlsecurity Security Question 0 Sign in to vote Hello all,I'm having a problem with my sa account, we just migrated from sql server 2000 to sql server 2005 and 1 of our production applications is failing on the sa login. I checked the 'User Map' setup to the 'sa' account and the databases that need accessing aren't mapped.When I try to cannot use add the map, I get error "Cannot use the special principal 'sa'. (Microsoft SQL Server, Error: 15405)". I get the same error when trying to remove a user map for sa (there are a couple db's already mapped), and I don't remember how I mapped them in the first place, but it certainly isn't working now!Thanks in advance,102020 Wednesday, September cannot use the 13, 2006 6:20 PM Reply | Quote Answers 9 Sign in to vote I found the solution!! Quit simple: exec sp_changedbowner 'sa','true'. Thanks anyway Friday, February 16, 2007 7:58 AM Reply | Quote 3 Sign in to vote Hey, I find out how to change it using Management Stadio Express: Right click the database to show properties. then change the owner under files to sa then you can map it under Logins . Thursday, March 15, 2007 8:29 PM Reply | Quote 0 Sign in to vote I have fixed this already, thanks though.The problem was that the db owner was the domain admin and not sa, so I couldn't change the mapping.Thanks,102020 Friday, September 15, 2006 4:10 PM Reply | Quote All replies 0 Sign in to vote What is ther error that you get back and for waht operation do you get it back? Please also check the server error log and copy the relevant errors logged there. ThanksLaurentiu Thursday, September 14, 2006 10:07 PM Reply | Quote Moderator 0 Sign in to vote I have fixed