Oracle/MSSQL/MySQL

Windows could not start the SQL Server service on local computer 17051: A network-related or instance-specific error occurred while establishing a connection to SQL Server

SQL-EvaluationExpired

The SQL Server is a relational database management system from Microsoft. The system is designed and built is to manage and store information. The system supports various business intelligence operations, analytics operations, and transaction processing. Kindly refer to these related guides: How to use Software Licensing Management Tool (slmgr) to install and uninstall Windows product key, What are the differences between various Editions of Microsoft SQL Server, and how to install MSSQL Server 2019 Developer Edition and SSMS on Windows, and how to download and install Microsoft SQL Server 2019 Express edition and SSMS, and the server was not found or was not accessible: A network-related or instance-specific error occurred while establishing a connection to SQL Server.

When you try to start the SQL Server service, the following error below will be prompted "Windows could not start the SQL Server service on local computer 17051".

Reason for the error

The reason why the SQL service could not be started is that the SQL Server Evaluation period has expired.

Screenshot-2022-02-24-at-17.39.36

When you try to open the SSMS (SQL Server Management Studio) and try to connect to a SQL Instance, the following error below will be prompted “. SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. 

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
Screenshot-2022-02-24-at-17.48.05

We have been directed to also take a look at the Event Viewer, as you can see below, the error message from the Event Viewer with event ID 17051, which shows SQL Server Evaluation period has expired under the General section.

Screenshot-2022-02-24-at-18.00.27

Solution

I have installed SQL in my Lab using the Evaluation of 180 days because you didn’t apply any Product Key. So, now how can you make it live again? All you need is a Product key of SQL Server now. Please refer to this guide on “how to upgrade MS SQL server instance edition”.

Since we are aware that the evaluation period has expired, please refer to these links {1} and {2} on how to upgrade your evaluation software.

I hope you found this blog post helpful. If you have any questions, please let me know in the comment session.

Subscribe
Notify of
guest

0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x