January 16, 2009 at 8:03 am
Hi All
I was not able to connect to the SSMS database engine , when I checked the SQL services SQL server and SQL server agent were not running .
I manually started both these services and they started running without giving me any error, however when I refreshed the SQL server 2005 services page I found that both those services stopped working again.
Any idea why these services are not running continously?
Gaurav
January 16, 2009 at 9:53 am
Check the event viewer to see if it is throwing an error. Also try to see what the Error log shows.
-Roy
January 16, 2009 at 9:56 am
Hi
I checked the application log. below are the description for the error
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17300
Date: 1/16/2009
Time: 11:02:00 AM
User: N/A
Computer: XXXXXXXX
Description:
SQL Server was unable to run a new system task, either because there is insufficient memory or the number of configured sessions exceeds the maximum allowed in the server. Verify that the server has adequate memory. Use sp_configure to check the maximum number of sessions allowed. Use sys.sessions to check the current number of sessions, including user processes.
Any idea how to get rid of this
Gaurav
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply