Missing server express

Question

I need to install sql server express to be used by both Visual Studio 2015 and SQL Server Management Studio that are currently installed. It comes up as unavailable when I try to obtain it at the MS download center.

Answer 1

Hi elisch123,

Microsoft SQL Server 2019 Express
https://www.microsoft.com/en-us/sql-server/sql-server-downloads

Microsoft SQL Server 2017 Express
https://www.microsoft.com/en-us/download/details.aspx?id=55994

The latest general availability (GA) version of SSMS(SSMS 18.6)
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

Best Regards,
Cris

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

Thank you very much for your reply.  I finally established a connection through VS2015 after failing to

do so in SSMS.  Actually it was my second installation of SSMS.  I had tried every combination of responses to the connection screen getting the same rejection error every time.  Finally when I returned to VS, everything clicked indicating the connection had been made but wrongly indicated the failures. 

 

Answer 3

Hi elisch123,

Tanks for your reply.

So you have successfully installed an instance of SQL Server, but cannot connect to this instance from SSMS? Is it a local connection or a remote connection? Please display the error message from SSMS  for further diagnosis.

Best Regards,
Cris

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 4

Everything is now good Cris.