Hello,
The problem has re-occurred. I've uninstalled AntiVirus program, and disabled Windows Firewall, restarted SSMS but getting error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
Using: Windows Authentication. I've also re-enabled the stopped services in SSCM, i.e. SQL Server, but when I then attempt to re-start SSMS the SQL Server goes back to Stopped from Running.
Any ideas to fix?
Please look at the contents of the SQL Error log. Most likely some messages will indicate the reason for the SQL Server service to stop.
You don't need to have SQL Server service running to get the error log. You can just open the file ERRORLOG.# (being ERRORLOG the most recent error log, ERRORLOG.1 the previous, ERRORLOG.2 the pre-previous, etc.) with any text editor. By default these files are located in the folder "..\Microsoft SQL Server\MSSQL.1\MSSQL\LOG".
Additionally check the Windows Application eventlog for any entries related to the service to stop.
** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **