.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Cannot drop a "orphan" user because it does not exist

Posted By:      Posted Date: September 04, 2010    Points: 0   Category :Sql Server
I have a user identified as a orphan user that I cannot drop.  The user is not listed in the Logins folder or the Users folder for the database but when I query the database with select * from sysusers where name = '\xyz' it returns a row.  I get the following error when I try to DROP USER [\xyz]; OR exec sp_revokedbaccess '[\xyz]'.  Any ideas?  Msg 15151, Level 16, State 1, Line 2 Cannot drop the user '\xyz', because it does not exist or you do not have permission

View Complete Post

More Related Resource Links

The name 'User' does not exist in the current context.


Hey guys,

I've got a literal control to display the username of the user logged into our companies intranet system, originally I had a LoginName control but couldn't get strip to remove the domain from the username (as the format is domainname\username) so I'm trying it this way.

    protected void Page_Load(object sender, System.EventArgs e)
        string[] Parts = User.Identity.Name.Split("\\");

        if (Parts.Length == 2)
            loginName.Text = Parts[1];
            loginName.Text = User.Identity.Name;


    protected void Page_Load(object sender, System.EventArgs e)
        string[] Parts = User.Identity.Name.Split("\\");

User name instead of the AD User ID in the user logged in drop down

Hello All, The 2010 is showing Domain\user ID instead of User name when a user is logged in. Any one faced this and fixed the issue? Thanks, Pradeep

Cannot drop a user

Dear all, I have a login user whihc has been named dbo and attached to a windows login. I need to delete that user but SQL do not allows me to delete it whith the following lline : IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = N'dbo') DROP USER [dbo] Any idea why and how can I remove it ? regards sergeYour knowledge is enhanced by that of others.

User Specific Values for a Drop Down "Choice" Field

I would like to create a drop down field which has some fields disabled or not visible based on the user logged in.  Is this possible?

Unable to delete orphan user from sysusers

SQL Server 2005 I have an orphan user in the application database called  [ \opdbo]These are the following these i have tried       sp_droplogin   '[\opdbo]' go sp_dropuser   '[\opdbo]' go sp_dropalias   '[\opdbo]'   EXEC   sp_addlogin '[\opdbo]' , 'Test123', 'opprod' GO EXEC   sp_change_users_login 'update_one','[\opdbo]' , '[\opdbo]' zero rows come up with this query SELECT   UserName = name FROM sysusers WHERE   issqluser = 1 and (sid is not null and sid <> 0x0) and   suser_sname(sid) is null ORDER   BY name     But the user shows up in select * from sysusers   I did find some articles where it says to sign in as DAC.  Is there any other way to delete this user? Lori

Create a picture that can be marked by the user using drag and drop

I am trying to see if it's possible for me to have a picture like of a car and have it to where users are able to take a symbol and mark up the diagram with it.  Without needing a template pen.  Thanks for any help and advice.

SQL Express 2008 install error 84B40000 "The Windows account somain/user does not exist and cannot b


Full reported error

StdOut -2068578304: The following error occurred:
The Windows account doman\user does not exist and cannot be provisioned as a SQL system administrator
Error result: -2068578304
Result facility code: 1204
Result error code: 0

domain/user is a domain administrator and also a local administrator and is the currently logged in user.  This failure is happening as part of A Citrix XenApp 6.0 configuration which was started as an Administrator

A Google search for
"The Windows account" "does not exist and cannot be provisioned as a SQL system administrator"
Came up with absolutely nothing.

A Google search for -2068578304 failed to find anything, which did not surprise me.

-2068578304 translates into hex as 84B40000.

A Google search for 84B40000

Comes up with a fair few different textual descriptions with the same error code, which I am wading through.

Any help would be welcome.  I am also asking my friends at Citrix.


With thanks in advance.


The user does not exist or is not unique


We have just used the following link to update our object cache user accounts and after IISRESET we are now getting the above message, and are unable to access our intranet site.

We created two new AD accounts with minimal network privileges, as these would be defined within the Central Admin, as either Full Control or Full Read.

Has anyone else updated their Cache Users and did they have a similar problem, did they create new AD accounts for this or use existing ones?

Quick turn around would be nice, how can I tell what setting has been made within powershell for the portalsuperuseraccount and portalsuperreaderaccount.


calendar - incoming email error - The user does not exist or is not unique..


I am sending calendar appointments to a sharepoint calendar.  It works fine if i send from my exchange email on the domain.  However if i try to send from outlook, which has a gmail (live account same error) account off network, the mail comes to the drop folder on my incoming email sharepoint server but then i get this error:

An error occurred while processing the incoming e-mail file C:\inetpub\mailroot\Drop\4ab7332801cb38a6000000c7.eml. The error was: The user does not exist or is not unique..

next error is

The Incoming E-Mail service has completed a batch.  The elapsed time was 00:00:00.0625004.  The service processed 1 message(s) in total.  Errors occurred processing 1 message(s): Message ID: <000001cb38a5$00a4f100$01eed300$@com>

external users can just find send email and documents to other document libraries but this calendar is giving me problems.

all servers sharepoint 2007 sp2 enterprise edition.


The user does not exist or is not unique


Hi Guys ,

  When i create a new group in sharepoint it gives me the this error

 The user does not exist or is not unique

I also cannot add add users.

I can create groups using stsadm -o creategroup .


Please help


Cannot drop a login because the user is logged on


I want to be able to drop a login forcefully even if the login is currently logged on, its a SQL login. I have tried setting the database offline and online but that does not seem to do the trick, the way I do this is to restart the SQL service, but this often require logging onto the server to do this, I was wondering whether there are other options other than restarting the service.

If I disable the login, the login is still connected because the connection persists from the application unless SQL is restarted or unless the application is restarted.

Any ideas ?

can not drop user from database


 I can not delete user from a database in sql2005 beta 3.
the message errror is :

TITLE: SQL Server Management Studio

Drop failed for User 'Amministratore'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft SQL Server&ProdVer=9.00.0981.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+User&LinkId=20476


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


The database principal owns a schema and cannot be dropped. (Microsoft SQL Server, Error: 15138)

in sql 2000 I can delete the user very easy, but in sql 2005 I don't understant How to do it.

Either the xxx user does not have permission to access the yyy object, or the object does not exist.


Following examples from Wiley's DM with MS SQL Server 2008 book. Have created a mining model I am not able to train. Up to do point where I use openquery to try to train it, everything goes smoothly. When openquery is run, I get the message: Either the xxx user does not have permission to access the yyy object, or the object does not exist. Obviously, the object exists and I as a db owner should be able to access it. Have double and tripplechecked logins/roles/permissions but have no clue what could be the showstopper.
I am stuck with this issue for some time and would highly appreciate any help to move forward. Have exhausted my ideas and have not been able to find applicable resolution to my problem by querying forums.
Thanks in advance.

MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

Binding the multiple drop down boxes in GridView using JQuery in ASP.NET

Here is the code for binding the multiple drop down boxes in GridView using JQuery in ASP.NET

Choosing Between a User Control or Web Part for SharePoint

SharePoint will only display Web Parts on a page. However, there are publicly available shims that allow you to write user controls and have them be displayed as a Web Part. From SharePoint's point of view, the shim is a Web Part. From the point of view of the user control, the shim is simply a control in .NET that is including the user control

Creating Sites/Lists/List Items under Current User Context in SharePoint By Using SPUserToken

Usually we do this by performing the action under RunWithElevatedPrivileges method and updating the listitem using SPListItem.SystemUpdate() method (see here). but this approach has its own flaws like (RunWithElevatedPrivileges will run under system account, we cannot use SystemUpdate for SPSite,SPWeb,SPList, since it runs under system we will "CreatedBy" by as SystemAccount).
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend