locked
Lock windows authentication logins RRS feed

  • Question

  • Hi All,

    How can we lock and expire the windows authentication logins?

    Thanks in advance.

    Thanks

    Shashikala

    Tuesday, December 10, 2013 11:10 AM

Answers

  • Hello Shashikala,

    You can disable a Windows server login in SQL Server, if it's that what you mean:

    USE [master]
    GO
    
    ALTER LOGIN [DOMAIN\UserName] DISABLE
    GO
    


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by bhat BK Tuesday, December 10, 2013 11:25 AM
    Tuesday, December 10, 2013 11:14 AM