Error 15045
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 Sa Microsoft Sql Error 15405
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 4.7 million cannot drop the user dbo 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 Alter 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,055164597 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
Sp_changedbowner
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 fu
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 the special principal 'sa'. (Microsoft SQL Server, Error: 15405) [Answered]RSS 2 replies Last post login failed for user sa 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 sql server change database owner 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 run into this, because I can't findany posts about it that are helpfull. I just http://stackoverflow.com/questions/4644233/cannot-use-special-principal-dbo-error-15405 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 - andsa properties If I try to add user sa to my Db I get the following errors: >>>------------------------------------------------------------------------------------------------------------->>> Create failed for User http://forums.asp.net/t/1199655.aspx?Cannot+use+the+special+principal+sa+Microsoft+SQL+Server+Error+15405+ '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 of security node. And you may right click on the sa account, choose “Properties”, and then switch to the ‘Status’ tab, please make sure that you have enabled the login of that account. Thanks. Please mark the replies as answers if they help or unm
each of cannot use the causes, check the following: Check the Tape Server Messages topic and follow the instructions for media or cannot use the hardware errors. Check the Tape Related Errors Help topic.If this error indicates a tape hardware error, see the media error Help topic.A device on the SCSI bus has caused an unscheduled reset, which caused the tape drive to abort all operations. ©2005 Computer Associates International, Inc. All rights reserved.
caused by corrupted or damaged system files. In my experience, if you are getting windows error 15045 then there is as much as chance that it is occurring because of registry problems. This error should be fixed as soon as possible to prevent further damage of windows system such as system not responding, can't able to windows update, application error, blue screen error etc. To fix windows problem you need to do the following steps: Download Windows Error 15045 Repair Tool Compatible:Windows 98, 2000, ME, XP, Vista, 7, 8 (32/64) File Size: 4.9MB (IMPORTANT) Instruction to Fix Windows Errror 15045 Step 1. Click here to download PC repair tool 15045 Step 2.Install and Open the Tool to run Step 3.Scan and Click on "Fix All" button PC Repair Tool Features PC Repair Tool - Reimage is fully designed for scan and repair diagnose problem in your system and it can quickly clean windows registry files. It can monitor all the running process and Increase system security for removing malware, spyware or adware from PC Good Luck!! Park Johnson User Comments By Mical Joshef 08:15:00 AM Thanks for the great tool, now my pc is safe from 15045 issue. It really amazing software i recommended to all who also facing the same problem. Thanks!!! By Martin Decosta 05:45:00 PM Really a huge thanks for your suggestion...finally this irritated error 15045 removes from my computer. Now I feel relaxed. By Jenny Smith 12:15:00 PM There is no any idea how 15045 error occur on my pc but now it has been solved. Thanks to Reimage!!! Park Johnson Have experience of managing 5000 pcs Solutions I have tried all most 10 software to fix windows error 15045 in my company, finally i found this one work best. Download Software System Requirements Internet Connection 20MB Free Hard Disk Space 1024MB of Ram Login as Administrator Repair Tool Screenshort SiteMap Home Free Download Buy Now Privacy Policy Affiliate Disclosure Terms & Conditions Contact Us Category stoperror1