I SQL2008 database as the data source to develop a commodity enters sells saves the software, but recently in a software use units often appear in the configuration manager is SQL2008 SQL SERVER (MSSQLSERVER) and SQL SERVER (MSSQLSERVER) agent in the computer after the interruption, the user cannot use software,
I have set the two startup mode in advance to automatically, but also a dropped after the computer connection,
Respect to computer expert advice, what is the reason? How to solve? Be very grateful!

CodePudding user response:

Log look at the inside, what is the problem to stop,

CodePudding user response:

System event logs and SQL logs to check

CodePudding user response:

Check the SQL Server error log (with tablet or notebook open), positioning to the exception occurs before, during and after the point in time to see details of exception.
The following default path for SQL Server error log file (the path of the installation environment differ slightly different).
C: \ Program Files \ Microsoft SQL Server \ MSSQL10_50 MSSQLSERVER \ MSSQL \ Log \ ERRORLOG

CodePudding user response:

Thanks to the teacher's guidance!