Windows could not start the SQL Server (MSSQLSERVER) service on local computer error 3417. For more information review the System Event Log.'

Analyst_SQL 3,531 Reputation points
2020-09-22T15:58:54.987+00:00

I am facing error when i am starting sql service
Windows could not start the SQL Server (MSSQLSERVER) service on local computer error 3417. For more information review the System Event Log.'

what could be the issue.?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,323 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,524 questions
{count} votes

Accepted answer
  1. m 4,266 Reputation points
    2020-09-23T04:23:04.827+00:00

    Hi @Analyst_SQL ,

    what could be the issue.?...MDF CURROPT ,giving alert

    There are many casues for Error 3417, please reference this doc. to fix this error: how-to-resolve-sql-server-error-3417

    And if your mdf curropt, please firstly execute code:

    DBCC CHECKDB   
    

    And then you can reference this doc to repaire your mdf files: how-to-repair-mdf-file-in-sql-server-database

    BTW, do you have any backup files? If yes, you can restore your backup files.

    More information : dbcc-checkdb-transact-sql,quickstart-backup-restore-database

    BR,
    Mia


    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Tom Phillips 17,711 Reputation points
    2020-09-22T18:25:46.087+00:00

    That is a generic "failure to start service" message and in no way helps diagnose the actual problem. Please look at the system event log for the actual error.

    1 person found this answer helpful.
    0 comments No comments