Member Avatar for deepu123

Hi.....

i create a new user in mssql... user is --- kumar

now i login to mssql by using the above user...

now i login to mssql with another console by using administrator account.....

now i try to delete the account(@ present in administrator account) -- kumar
....

then the kumar account not deleted....and shows the following error message...

do not delete the account currently logged in

...........
please solve my problem...

Regards,
deepu

  • 2 Contributors
  • 1 Reply
  • 129 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by itsdavetime
Member Avatar for itsdavetime

You can't drop a user if they are currently logged in. Do an sp_who to find the SPID's the user is logged in with, and kill those spid's. Then drop the user.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.