[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 455
  • Last Modified:

SQL SERVER 2008 service not starting

uable to start the service showing error attache. please suggest solution
SQLstarterror.JPG
0
ajaygund
Asked:
ajaygund
1 Solution
 
CaptainGibletsCommented:
can you post any messages from the event viewer that are generated when you try to start the service.
0
 
ajaygundAuthor Commented:
providing event viewer image for reference
EventViwer.JPG
0
 
CaptainGibletsCommented:
have you changed the service account that sql runs under recently?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
ajaygundAuthor Commented:
yes
0
 
CaptainGibletsCommented:
Check the permissions of the new account that you created to the log file location it is normally
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Seems like you moved your Error log file/ directory and this should help you fix it

http://blog.justinho.com/2008/01/13/SQLServer2005ErrorLogDirectoryIsRemovedFromServerServiceFailsToStart.aspx
0
 
ullfindsmitCommented:
Update the username and password for the service's startup credentials
Or make it start under SYSTEM

Also, could be caused by the computer not being able to connect to your DC
0
 
ajaygundAuthor Commented:
solution work partially,

part which is really helps is checking credential
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now