17051

"windows could not start the sql server on local computer" SQL Server Error 17051 

Reason:

- SQL Server 2016 Evaluation: Evaluation period has expired (6 months ~ 180 days)

We have 2 solutions:

1. Reinstall

2. Edition Upgrade: SQL Server Installation Centrer > Maintenance: Edition Upgrade > Specify a free edition: Developer


Attach a SQL Server Database without a Transaction Log File

Reason:

- You don't have log file (.ldf file)

Solutions:

- Using SQL Server Management Studio: just click not found ldf file then click "remove"