question

SamirAbbasfard-1820 avatar image
0 Votes"
SamirAbbasfard-1820 asked SeeyaXi-msft commented

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

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-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SamirAbbasfard-1820 ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya

0 Votes 0 ·
DanGuzman avatar image
1 Vote"
DanGuzman answered

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @SamirAbbasfard-1820,

The agent is not visible if you use SQL Server Express. So I guess you are using the Express edition.
See this link:https://docs.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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SamirAbbasfard-1820 avatar image
0 Votes"
SamirAbbasfard-1820 answered

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



screenshot-2.png (131.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SamirAbbasfard-1820 avatar image
0 Votes"
SamirAbbasfard-1820 answered SeeyaXi-msft commented

138039-screenshot-1.png



screenshot-1.png (61.5 KiB)
· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

So did you install SQL Server or did you only install SQL Server Management Studio? SSMS is not SQL Server, and not is the SQL VSS Writer.

Check out the link in Dan's post above.

0 Votes 0 ·

i downloaded and installed it from the link bellow

https://aka.ms/ssmsfullsetup

0 Votes 0 ·
OlafHelper-2800 avatar image OlafHelper-2800 SamirAbbasfard-1820 ·

The link is for SSMS, the management tool and in your screenshot I don't see any SQL Server database engine service, so you don't have a running SQL Server, only the tool SSMS.

0 Votes 0 ·
Show more comments

Hi @SamirAbbasfard-1820,

Welcome to Microsoft Q&A!
I want to add something about what Erland said.
SQL Server is database engine while SQL Server Management Studio is GUI Administration Tool for working against the SQL Server engine.

Best regards,
Seeya

0 Votes 0 ·