Microsoft Sql Server can operate in two Authentication Modes, the first is Windows Authentication, and the second is Mixed Mode. In Windows Authentication Mode only the users, which have Windows Accounts (either Active Directory or Computer Accounts) can login to Sql Server. In Mixed Mode we can create in Sql Server logins, which do not have corresponding Windows Accounts. Windows Authentication Mode is suggested by Microsoft as the best practice; however Sql Server DBAs often have to configure Mixed Mode, because there are numerous applications on the market, which requires it. Ability to quickly check authentication mode of Sql Server is crucial if we are performing an audit or we have to work on an instance, on which we do not know anything.
Recent comments
48 weeks 6 days ago