Topic: R6 stops working
If R6 is working and then suddenly will not open, because it fails to open the database then this is probably caused by the Sql server stopping. This seems to be a common problem with Windows 10. It should be possible to start the service again. The way this is done will vary depending on the operating system. With Windows 10 if you type in 'Services' in the Windows 10 search box this should bring up near the top of the list 'View Local Services'. Clicking on this will open up a list of local services and in there you should find SQL Server Services. You should be able to start the service there. With Windows 7 go to Control Panel, System Security, Administrative Tools, Services. Look for the SQL Server. You should be able to start the service by right clicking on this and choosing 'Start'. The start type should be set to automatic - it can be changed through the properties of the service
I think this problems happens following some Windows upgrades, so once the service is restarted the problems goes away until another upgrade stops the service.
Do not try to reinstall SQL server or R6 until all other options have been tried.
Also worth knowing is that Configuration Manager for SQL Server is best accessed in Windows 10 by searching for 'Computer Management'. This will provide access to the SQL Server Services and other configuration options previously available through Configuration Manager.
Littlefield Consultancy - IT Consultants