December 18, 2013 at 6:07 am
Sounds like it could be permissions based. Are you a sysadmin on the SQL server?
Either way;check the sql log files and/or event logs for the reason that the service did not start. That should give you the clues to resolve
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
December 18, 2013 at 8:19 am
Actually I solved the problem. Initially some how error log was missed, at that time I couldn't able to connect to the Sql server. Then I created new Log and gave sharing permissions. Then the Sql server started working but Sql Agent is not connecting it missing the file SqlAgent.Out all the Sql agent error logs missing. So I gave \ErrorLog in the Log folder then it started working fine
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply