Microsoft Sql Server Error 15405
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) 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 cannot use the special principal sa user mapping Security Question 0 Sign in to vote Hello all,I'm having a problem cannot use the special principal 'dbo' sharepoint with my sa account, we just migrated from sql server 2000 to sql server 2005 and 1 of our 15405 belt 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 add
Cannot Drop The User 'dbo'.
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 13, cannot alter the user 'dbo' 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 this already, th
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 15405 Cannot use special principal SA login failed for user sa Rate Topic Display Mode Topic Options Author Message E McNeillE McNeill Posted Saturday, November 4, 2006
Sp_changedbowner
8:27 PM Forum Newbie Group: General Forum Members Last Login: Monday, June 27, 2016 11:52 AM Points: 7, Visits: 26 Using sql Server 2005Everything was
Alter Authorization On Database
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 failed for user 'SA' because the account is currently https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c2dc1237-5a33-48f8-9c11-e2c51424b198/sa-user-map-error?forum=sqlsecurity 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 as SA and got the same results listed above.4. I don’t have a http://www.sqlservercentral.com/Forums/Topic320530-119-1.aspx 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: Today @ 8:18 AM Points: 799, Visits: 8,120 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 Domain User account for password complexity and expiration.The Status page will allow you to unlock the account.sa already has implied access, there shouldn't be a need tASP.NET Community Standup Forums Help Home/ASP.NET Forums/Data Access/DataSource Controls - SqlDataSource, ObjectDataSource, etc/Cannot use the special principal 'sa'. (Microsoft SQL Server, Error:... Cannot use the special principal 'sa'. (Microsoft SQL Server, http://forums.asp.net/t/1199655.aspx?Cannot+use+the+special+principal+sa+Microsoft+SQL+Server+Error+15405+ Error: 15405) [Answered]RSS 2 replies Last post Jan 03, 2008 01:11 PM by Snowst ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options http://zamemon.blogspot.com/2012/02/cannot-use-special-principal-sa.html Advanced Search Reply Snowst Member 444 Points 204 Posts Cannot use the special principal 'sa'. (Microsoft SQL Server, Error: 15405) Dec 31, 2007 03:43 PM|Snowst|LINK Hello All, I'm hoping someone else has cannot use run into this, because I can't findany posts about it that are helpfull. I just updated our Dev SQL 2005dbto be able to use new 2005 key words with the script: EXEC sp_dbcmptlevel 'myDbName' , 90 This is all well and good until I notice mysa account no longer has a user mapping to my database.In managment studio when I go to Security - Logins - cannot use the andsa properties If I try to add user sa to my Db I get the following errors: >>>------------------------------------------------------------------------------------------------------------->>> Create failed for User 'sa'. (Microsoft.SqlServer.Smo) Cannot use the special principal 'sa'. (Microsoft SQL Server, Error: 15405) <<<-------------------------------------------------------------------------------------------------------------<<< I'm access the SQL Server through a client on my local machine, the Server is set to mixed authentication, actual check box is labeled Sql Server and WIndows Authentication Mode. Hopefully I'm just doing something dumb, which is highly likely since I'm a developer and not a DBA. Thanks in advance Reply Nai-Dong Jin... All-Star 35464 Points 3430 Posts Re: Cannot use the special principal 'sa'. (Microsoft SQL Server, Error: 15405) Jan 02, 2008 10:29 PM|Nai-Dong Jin - MSFT|LINK Hi, From your description, it seems that you are unable to use sa account to log in your sqlserver, right? In managment studio when I go to Security - Logins - and sa properties If I try to add user sa to my Db I get the following errors: If you are going to add a user called ‘sa’, that’s forbidden since it is a built-in account for SQLServer. Generally you can find the sa account in the logins tab o
from University of Sindh, Jamshoro, Pakistan. Wednesday, February 1, 2012 Cannot use the special principal 'sa'. (Microsoft SQL Server, Error: 15405) Yesterday, I start SQL Server 2005 and try to connect with sa user but was enable to connect with the 'sa' user and got this error:Cannot use the special principal 'sa' (Microsoft SQL Server, Error: 15405)After doing some google, I found out the solution which I am sharing so that others can get all the possible solutions from this article.The titled message mean that your sa user is disabled. To enable it, you have to follow below mentioned steps:1) you have to change the authentication mode: go to Management Studio and open Object Explorer. Connect to your server and right-click on the server name, then select Properties. Go to Security tab and under Server Authentication select "SQL Server and Windows Authentication Mode".2) Also, after you follow the directions above, you will also need to explicitly enable the sa account as well. Go to Security->Logins. Right-click on the "sa" account, select "Properties". In the list on the left, select "Status" and under "Login" on the right, make sure "Enable" is selected.3) exec sp_changedbowner 'sa','true' in query editor after selecting the database whom you want to assign user sa.4) You can also change the password of sa (it's better to change the password).After performing all above mentioned changes, Exit with SQL Management Studio. Restart Sql Service from services.msc.Open Management Studio again and try to login "sa". Hopefully, it works. Enjoy! (Please comment if it work for you). Posted by Zeeshan Ahmad Memon at 8:44:00 AM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: (Microsoft SQL Server, Cannot use the special principal 'sa', Error: 15405, Error: 15405), special principal 'sa' 2 comments: Anonymous said... Thanks for you help. March 16, 2016 a