Lee Markup walks us through an issue:
In my own local SQL Server I ran across a problem starting the SQL instance. I went to SQL Server configuration Manager and manually started the SQL Server instance. The UI showed the instance had started. I opened SSMS and tried to connect. And I waited, waited and waited some more until it didn’t connect and threw an error.
Read on to see how Lee was able to find and correct the issue without actually being able to start up SQL Server.