MSSQLServer service failed to start solution

Sometimes SQL Server fails to start because the MSSQLServer service does not start, and when you start manually, there are hateful error prompts that the service cannot respond to ...

The author "Lucky" met, my reason is the first 4, after upgrading finally can. Tangled for several days, and now summarize the possible causes and solutions:

Possible reasons for the above are:

1 , IP The address is not configured correctly:

Open Microsoft SQL Server 2005 Configuration tool, under SQL Server Configuration Manager , select MSSQLSERVER Protocol , then double-click the right window TCP/IP , check in the pop-up window IP configuration.

2 , possibly because VIA caused by protocol enablement. Here's how to fix it:

1) Open SQL Server the Configuration tool in SQL Server Configure Manager and Will VIA protocol Disable .

2) Restart SQL Server ( MSSQLSERVER ), Success .

3 , Administrator password modification can also cause SQL Server The service could not be started. Here's how to fix it:

Open Microsoft SQL Server 2005 Configuration tool, under SQL Server Configuration Manager , in MSSQLSERVER Service Properties, modify which account to start the service.

my machine can't start the service because it's enabled. "VIA" service, when disabled, OK up.

4. the SQL Server evaluation version is installed , and after the trial period of the day,MSSQLSERVER The service fails to start, and the 17051 error is reported manually .

Workaround:

First step: Enter SQL2008 Installation Center in the Configuration tool,

Step Two: Re-entry 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.  

with Key launch after successful upgrade MSSQLSERVER service. If you start SQL SERVER Manager and still report an expiration error, the registry hkey_local_machine\software\\ Microsoft\microsoft SQL server\100\configurationstate, Change the key value of commonfiles to 3 .

then repeat the above four steps to upgrade OK up.

No matter when the above solution, can only reinstall ....

MSSQLServer service failed to start solution