sql-serverpowershellssmspowershell-3.0

I have installed SQL Server 2019 via PowerShell but I am not able to open SSMS


I have installed SQL Server 2019 via PowerShell, the installation completed successfully, but I am not able to open SSMS (Microsoft SQL Server Management Studio). I have one Windows server with working SSMS. I have logged in that server and type SSMS in all program and right click SSMS and "Open file location".

I have noticed Microsoft SQL Server Tools folder and SSMS binary was present in the folder. I have tried the same in the not working server. I was not able to find the folder at all. I have attached the both working and non working screenshots in the attachment. Also attached the screenshot of package which I have installed. I have no idea what went wrong. Maybe configuration.ini file went wrong or something else.

Experts need your suggestion to fix this issue.

I am looking forward to hearing from you.

Thanks in advance

enter image description here

enter image description here

enter image description here


Solution

  • SQL Server - the core database components (engine) do not include SQL Server Management Studio (SSMS).

    You need to download SSMS separately and then install it afterwards.