Dropping a login from a master db of a Synapse serverless SQL pool

Question

Hi,

I need to drop my login from a master database of a Synapse serveless SQL pool avoiding "Could not drop login 'xxxx@yyyy.com' as the user is currently logged in" error.

My login is a Microsoft Entra user and I'm using SSMS to drop my login.

My Microsoft Entra user is a Synapse Administrator for the Synapse workspace.

Any suggests to me, please? Thanks

Answer 1

Hi @pmscorca ,

Thankyou for using Microsoft Q&A platform and thanks for posting your query here.

I understand that while trying to drop Login , you are facing this error: "Could not drop login 'xxxx@yyyy.com' as the user is currently logged in".

Kindly try to Terminate All Sessions for the Login before dropping the login.

• First, you need to terminate any active sessions for the login you wish to drop. You can use the following SQL command to kill all sessions for that login:

-- Replace 'xxxx@yyyy.com' with your actual login name
DECLARE @kill varchar(max) = '';
SELECT @kill = @kill + 'KILL ' + CONVERT(varchar(5), session_id) + ';'
FROM sys.dm_exec_sessions
WHERE login_name = 'xxxx@yyyy.com';
EXEC(@kill);

• Post that, drop the login: DROP LOGIN [xxxx@yyyy.com]; Hope it helps. Kindly accept the answer by clicking on Accept answerbutton. Thankyou

Answer 2

DROP LOGIN sounds like a good command. But obviously, you need be logged in with a different login than the one you are trying to drop. And you need to make sure that the login you are trying to drop is not connected.