Unable to connect to SQL Server database initial Win 2017 boot up. The error message looks like network related but I was able to connect to it locally either. It turned out that the Microsoft SQL Server Database Engine was not running even though, it has been set to Auto Start.
Get to SQL Server 2017 Configuration
After starting the SQL Server, I was able to connect.
Moving the SQL Server to SSD drive enable the SQL Server engine to start upon Windows Server starting up. My guess is, this may be due to slow disk causing the SQL Server engine to timeout on trying to start the service when Windows first starting up.
No comments:
Post a Comment