This was odd, as the builds have been working fine until this point. This was a wild goose chase to check the settings of the sql server, hosts file, testing pings etc …
Update 2/23/2020 10:15 PM CST:
- Update a development machine (not a build) with the same updates and the auto close was false – so hopefully it was an one off. This is good !!! 🙂
It came down to the “Auto close” was set to “True”, after changing that to “False”, we can see that now builds are getting done successfully.
Some readings/ view on auto close feature in sql server
The hints pointed to to look at auto close were as:
- DBCC Check was running again and again the AxDB, which normally shoudn’t happen.
- It was seen that AxDB start event was coming in the Application logs too frequently.
Hopefully it will help other folks as well, if such error is seen in the logs.
You can do this by SSMS UI or using following command on a database:
ALTER DATABASE [AxDB] SET AUTO_CLOSE OFF;