Forum Discussion
SQL Server Management Studio AND SQL Server Express Installation failure
I am a student in a continuing education GIS program. My instructor has tasked me with downloading and installing SQL Server Management Studio (SMSS) v.17.2, and SQL Server Express 2019, and I have been given direct links for both downloads.
https://go.microsoft.com/fwlink/?linkid=854085
SQL Server Downloads | Microsoft
The first link for SMSS starts the download, no problem. The install also was not a problem. However, when I first attempt to connect to a server, I get this error message.
The install for SQL server failed outright. Please see below.
Please advise on both.
MattMoir , I can't see anything in that miniature screenshots.
Please post the full error message as text, not as screenshot.
Also, View and Read SQL Server Setup Log Files - SQL Server | Microsoft Learn for more details about the error.
for SMSS
"Cannot connect to localhost\sqlexpress. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Netowrk Interfaces, error 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)"
For SQL Server 2022 Express Edition
"Oops... Unable to install SQL Server (setup.exe). Exit code (Decimal): -20618936006Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes."
I will attempt to uninstall and reinstall SQL Server because I am now aware that it will affect the ability for SMSS to connect to the server.
- See the link I posted before and review installation log files for details about the error cause.
