As long as we don't need this user, we are fine to let the user in disable state. But if we have to enable this user, what do we need to do?
If we Deny on Connect permission then the user get disable and by granting Connect permission will enable the user.
Right Click on User and go to properties
--Enable DataBase User( Provide Connect Permission on Database) use [YourDataBaseName] GO GRANT CONNECT TO [YourDatabaseUserName] GO --Disable DataBase User( Deny Connect Permission on Database) use [YourDataBaseName] GO REVOKE CONNECT TO [YourDatabaseUserName] GO