ssms 18.9.1 successfuly installed on windows 10 and SQL Server Agent is not visible in services.msc

Samir Abbasfard 1 Reputation point
2021-10-05T15:53:41.2+00:00

I have ssms v18.9.1 installed in windows 10 but it does not work and sql server agent is not displayed in services.msc

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,653 questions
{count} votes

4 answers

Sort by: Most helpful
  1. Dan Guzman 9,206 Reputation points
    2021-10-05T17:17:39.537+00:00

    SSMS is only a client application. The install does not install the database engine or SQL Server Agent.

    For development and testing, install Developer edition, which includes SQL Server agent. SQL Server Agent is not included with the Express Edition of SQL Server.

    1 person found this answer helpful.
    0 comments No comments

  2. Seeya Xi-MSFT 16,436 Reputation points
    2021-10-06T02:59:08.843+00:00

    Hi @Samir Abbasfard ,

    The agent is not visible if you use SQL Server Express. So I guess you are using the Express edition.
    See this link:https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-version-15?view=sql-server-ver15#SSMS
    Here is a document about Upgrade to a Different Edition of SQL Server.
    If I misunderstood what you mean please let me know.

    Best regards,
    Seeya


    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  3. Samir Abbasfard 1 Reputation point
    2021-10-06T06:44:29.293+00:00

    my main problem is sql server management not work. as you can see the picture, after applying the following settings

    =================================

    Server Type : Database Engine
    Server name: localhost
    Authentication: Windows Authentication

    ==================================

    Unfortunately I get the next image error, please help me solve this problem 137909-screenshot-2.png

    0 comments No comments

  4. Samir Abbasfard 1 Reputation point
    2021-10-06T06:45:39.627+00:00

    138039-screenshot-1.png