What is SQL server agent and what are the two modes of authentication in SQL Server?


Posted On: Feb 22, 2018


SQL Server agent
The SQL Server agent plays an important part in the day to day tasks of the SQL Server Database Administrator (DBA).
Its purpose is to implement the tasks easily with the Scheduler engine that allows our tasks to run at a scheduled time and date.
Modes of Authentication in SQL Server
The two authentication modes in SQL Server are:
  • Windows Mode
  • Mixed Mode

From the tools menu of SQL Server configuration properties in the security page, the modes can be changed.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Mssql Interview Questions

    What is MSSQL?

    MSSQL stands for Microsoft Server SQL that is a Microsoft’s relational database management system. It is a featured d..

    Mssql Interview Questions

    What is SQL Profiler?

    It is a tool that allows system’s administrator to monitor the events in SQL Server.It is mainly used to capture and ..

    Mssql Interview Questions

    What is COALESCE and CHECK constraint in SQL server?

    COALESCE – It is a function that is used to return the first non-null expression from more than one column within the..