How to logoff another user from sql server

How to logoff a user from SQL  Server

It is obvious that a single server may be accessed by several people at a time. We can logoff active/inactive users from the SQL server as per requirement.

It is simple and very easy task need to perform as steps given below:

Open the task manager –> Go to users option –> Select the user –> Logoff



Note:  Take precautions while logging off the user.

  • You must have full control permission in case of logoff another user from a session.
  • You should send a message to the users before taking this action because logging off a user without warning can result in loss of data on the user’s session.



About Mirza Husain

Mirza Husain is a senior consultant-database and having more than 10+ years of experience in the IT industry with different domains. He is fond of writing and speaking about SQL Server and also keen to learn new technologies. He is holding MCA degree and having Microsoft certifications as MCP & MCTS. He is also ITIL certified. In his past years, he worked with many clients as Microsoft, Bank of America etc. Currently he is associated with a France based client and offering his best services. You may reach him on his email id -- Thanks!
This entry was posted in Database Administration, Security, Uncategorized. Bookmark the permalink.

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s