1. Basic phenomenon: The MSSQLServer service cannot be started, and a 17051 error is reported by manual start.
2. Workaround:
First step: Enter the installation center in the SQL2008 Configuration tool,
Second step: Re-enter the maintenance interface, select Version upgrade,
Step three: Entering the product key, entering the key
Developer: pttfm-x467g-p7rh2-3q6cg-4dmyb
Enterprise: JD8Y6-HQG69-P9H84-XDTPG-34MBB
Fourth step: Always point to the next step until the upgrade is complete.
Finally, the MSSQLServer service can be started after the key upgrade is successful.
In addition, the following error occurred when connecting to the database:
Unable to connect to (local).
------------------------------ Additional information:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or could not be accessed. Verify that the instance name is correct, and that SQL Server is configured to allow remote connections. (provider: Named pipe provider, ERROR:40-Unable to open connection to SQL Server) (Microsoft SQL Server, error: 2)
For help information, click: Http://go.microsoft.com/fwlink? prodname=microsoft+sql+server&evtsrc=mssqlserver&evtid=2&linkid=20476
In fact, the MSSQLServer service is not open, just open the service on the line.
The above are all the problems that have been encountered before, in the process of solving, once also has been distressed, now write in here, even if it is to remember a note, but also to the beginner a little help!
About SQL Server 2008 expiration causes the MSSQLServer service to fail to start, and the manual start reports error code 17051.