Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Unable to delete the database user as the user is already logged in currently. error 15434

Tags:

sql-server

sql-server-2012

I have created the user sagar in SQL Server 2012 database and mapped it to the XYZ database. After some time I deleted the XYZ database and now I don't need the existing user sagar also. But when I try to delete the user from SQL Srever Management Studio. I am getting the following exception

Could not drop login 'sagar' as the user is currently logged in. error:15434

like image 524
Sagar Pudi Avatar asked Apr 28 '15 06:04

Sagar Pudi

People also ask

Could not drop login as the user is currently logged in 15434?

Microsoft SQL Server Error 15434 This error generates when a login has made a connection to the SQL Server Instance and you are trying to drop the same login. Solution to fix this issue is to close all sessions which are opened by this login and then drop it.

How do I delete users in SSMS?

If you are using SQL Server Management Studio you can browse to the user and right-click selecting delete.

1 Answers

User can be deleted after killing the session by identifying the session_id of the user.

SELECT session_id FROM sys.dm_exec_sessions WHERE login_name = 'sagar'  KILL 51  --51 is session_id here, you may get different id

Now you can delete the login simply by executing the below query (or) by using sql server management studio options.

DROP LOGIN 'sagar'
like image 159
Sagar Pudi Avatar answered Oct 06 '22 17:10

Sagar Pudi
Sign in to Comment

Related questions

SQL Server @@SERVERNAME returning old machine name?
What is the use of a cursor in SQL Server?
How can I retrieve the logical file name of the database from backup file
How to use a TRIM function in SQL Server
Cannot create SSPI context
What's the correct name for an "association table" (a many-to-many relationship) [closed]
Disabling foreign key constraint, still can't truncate table? (SQL Server 2005)
How to set the default schema of a database in SQL Server 2005?
Is COUNT(*) in SQL Server a constant time operation? If not, why not?
Is there a way to disable a SQL Server trigger for just a particular scope of execution?
The equivalent of SQLServer function SCOPE_IDENTITY() in mySQL?
Entity Framework Mapping SQL Server tinyint to Int16
FileLoadException / Msg 10314 Error Running CLR Stored Procedure
Check if extended property description already exists before adding
TSQL Try / Catch within Transaction or vice versa?
what are the advantages of defining a foreign key
Get .sql file from SQL Server 2012 database
SSDT-BI SSIS in x64?
SQL Server: How to list all CLR functions/procedures/objects for assembly
I/O Error: SSO Failed: Native SSPI library not loaded

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!