Skip to content

Latest commit

 

History

History
31 lines (25 loc) · 1.63 KB

File metadata and controls

31 lines (25 loc) · 1.63 KB
title SQL Server Agent Service cannot use SQL Server Authentication | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology database-engine
ms.topic conceptual
helpviewer_keywords
authentication [SQL Server Agent]
SQL Server Authentication [SQL Server Agent]
ms.assetid c39f3ec3-fc2c-4c12-940f-60d8d3d17660
author mashamsft
ms.author mathoma
manager craigg

SQL Server Agent Service cannot use SQL Server Authentication

[!INCLUDEssNoVersion] Agent only supports Windows Authentication when the [!INCLUDEssNoVersion] Agent service connects to an instance of [!INCLUDEssNoVersion].

Component

[!INCLUDEssNoVersion] Agent

Description

In [!INCLUDEssNoVersion], the [!INCLUDEssNoVersion] Agent service can only log on to the database using Windows Authentication. This means that the [!INCLUDEssNoVersion] Agent service account must be a [!INCLUDEssNoVersion] user.

For more information, see the topics "Security for Automatic Administration" and "Implementing [!INCLUDEssNoVersion] Agent Security" in [!INCLUDEssNoVersion] Books Online.

See Also

SQL Server Agent Upgrade Issues