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 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
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 6.2 million
15405 Belt
programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Cannot use special principal dbo: Error 15405 up vote 25 down vote favorite 2 I am trying to give all
Cannot Drop The User 'dbo'.
the permissions to a user in the User Mapping section of a database. But, I am encountering this error: "Cannot use special principal dbo" Server roles of the user: sql-server share|improve this question asked Jan 10 '11 at 6:27 Cipher 2,060164598 1 Not an actual answer to the question posted, but since you're granting db_owner to sarin, why are you even trying to assign any other roles? –Damien_The_Unbeliever Jan 10 '11 at 8:02 cannot alter the user 'dbo' This is because I am trying to install a CMs on my website and during the installation process, it says, no User or role 'sarin'. See here: i.imgur.com/Intaa.jpg –Cipher Jan 10 '11 at 9:15 1 The user 'sarin' is already db_owner of the database, there's no need to grant any further permissions. If you're still getting this error, then you're not connecting to the database you think you are, but since you've not shown any screenshots of the actual point where you supply server/db/username, or a connection string, it's a little tricky to diagnose further. –Damien_The_Unbeliever Jan 11 '11 at 9:20 add a comment| 3 Answers 3 active oldest votes up vote 32 down vote accepted This is happening because the user 'sarin' is the actual owner of the database "dbemployee" - as such, they can only have db_owner, and cannot be assigned any further database roles. Nor do they need to be. If they're the DB owner, they already have permission to do anything they want to within this database. (To see the owner of the database, open the properties of the database. The Owner is listed on the general tab). To change the owner of the database, you can use sp_changedbowner or ALTER AUTHORIZATION (the latter being apparently the preferred way for fut
ASP.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 login failed for user sa the special principal 'sa'. (Microsoft SQL Server, Error: 15405) [Answered]RSS 2 replies sp_changedbowner Last post Jan 03, 2008 01:11 PM by Snowst ‹ Previous Thread|Next Thread › Print Share Twitter alter authorization on database Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply Snowst Member 444 Points 204 Posts Cannot use the special principal 'sa'. (Microsoft SQL Server, Error: http://stackoverflow.com/questions/4644233/cannot-use-special-principal-dbo-error-15405 15405) Dec 31, 2007 03:43 PM|Snowst|LINK Hello All, I'm hoping someone else has 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 https://forums.asp.net/t/1199655.aspx?Cannot+use+the+special+principal+sa+Microsoft+SQL+Server+Error+15405+ account no longer has a user mapping to my database.In managment studio when I go to Security - Logins - 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 u
not assigned to user database after UAT refresh. User was having "db_owner" but when I tried to assigning him other roles created for specific purpose we get below error "Cannot use special principal http://saurabhsinhainblogs.blogspot.com/2013/09/cannot-use-special-principal-dbo.html DBO" I tried togive other permissions to user in the User Mapping section of a database. But, I am encountering this error. On investigating I found: This is happening because the user is the http://zamemon.blogspot.com/2012/02/cannot-use-special-principal-sa.html actual owner of the database - as such, they can only have db_owner, and cannot be assigned any further database roles. Nor do they need to be. If they're the DB owner, they already cannot use have permission to do anything they want to within this database. To see the owner of the database, open the properties of the database. The Owner is listed on the general tab. To change the owner of the database, you can use 1. sp_changedbowner 2. Alter Authorization 3. From GUI : goto database properties , and change as below screenshot Changing owner of database to sa , will cannot use the allow you toassign anyrole toyour user Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest 4 comments: Dinesh Dattatray VisheMay 7, 2014 at 5:54 PMHi Saurabha,Done. but unable to change parameter.Regard,DineshReplyDeleteRepliesSaurabh SinhaMay 13, 2014 at 6:18 AMHi DineshAre you not able to change owner of database ?? it can be some valid user only. Please try to replace it wit sa.If you still face issue , Please mail me error and screen shot @ Saurabh.x.sinha@gmail.comDeleteReplyAnonymousSeptember 24, 2014 at 8:13 AMHello Saurabh,your tips above assisted me with setting up my ASPState session db with user sa in cmd.I had all the other settings updated in MySql Studio but not the actual db properties /File Owner. CheersReplyDeleteRepliesSaurabh SinhaSeptember 24, 2014 at 2:46 PMGood to hear ,it worked for youDeleteReplyAdd commentLoad more... Newer Post Older Post Home Subscribe to: Post Comments (Atom) Total Pageviews Follow by Email Followers Categories Audit (2) Backup Restore (14) Checkdb (3) Column Store Index (3) Configuration (1) Connectivity (3) DAC (5) Data Quality Services (1) DBA Scripts (4) Dead Lock (4) Demo (22) Development (2) Difference Between (13) DMV (2) Double-Take (1) DQS (1) DR (1) ERROR (48) Error Log (2) Firewall (2) High Availability (3) Indexes (9) Interview Questions (5) litespeed
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 at 8:40 AM amit Jain said... Thanks sir, it is working fine.. March 16, 2016 at 11:38 AM Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Visitors Origin Live Traffic Stats About Me Zeesh