SSMS Integration Server agent Regarding

Question

i have sql server management studio with integration services enabled, my doubt is whether admin/administrator can only start/stop the server agent?

Answer 1

Hi @Devaguru,

The service startup account defines the Microsoft Windows account in which SQL Server Agent runs and its network permissions. SQL Server Agent runs as a specified user account. You select an account for the SQL Server Agent service by using SQL Server Configuration Manager, where you can choose from the following options:

• Built-in account. You can choose from a list of the following built-in Windows service accounts:
  • Local System account. The name of this account is NT AUTHORITY\System. it's a powerful account that has unrestricted access to all local system resources. it's a member of the Windows Administrators group on the local computer.
• This account. Lets you specify the Windows domain account in which the SQL Server Agent service runs. We recommend choosing a Windows user account that isn't a member of the Windows Administrators group. However, there are limitations for using multiserver administration when the SQL Server Agent service account isn't a member of the local Administrators group. For more information, see 'Supported Service Account Types' that follows in this article.

Check Select an account for the SQL Server Agent service

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi Devaguru
In SQL Server Management Studio (SSMS), whether a user can start or stop the SQL Server Agent depends on the permissions granted to that user. The ability to start or stop SQL Server Agent is typically governed by membership in the appropriate roles or permissions at the SQL Server instance level

Members of the sysadmin fixed server role have full control over SQL Server Agent. This role includes the ability to start, stop, and configure the SQL Server Agent service

To check or modify SQL Server Agent roles and permissions:

1. Open SSMS.
2. Connect to the SQL Server instance.
3. Navigate to "Security" > "Logins."
4. Find the login for the user in question.
5. In the login's properties, check the server roles and permissions.

If this helps kindly accept the answer thanks much.