Не удалось запустить службу sql server код ошибки 17113

Не удалось запустить службу SQL Server на Локальный компьютер. Подробности содержатся в журнале системных событий. Если эта служба разработана не в Майкрософт, обратитесь к разработчику службы, и сообщите специфический для этой службы код ошибки…:

Код ошибки 13

Решение:

При появлении данной ошибки необходимо зайти в Пуск → Microsoft SQL Server → Средства настройки → Диспетчер конфигурации SQL Server / SQL ServerConfiguration Manager → Конфигурация сети SQL Server → Протоколы для SQLEXPRESS и проверить, включены ли протоколы (все протоколы должны быть включены).

Код ошибки 1814

Вариант ошибки на английском:
Windows could not start the SQL Server on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code — 1814.

Причина: Ошибка возникает, когда по какой-то причине путь к файлам базы по умолчанию не соответствует действительному.

Решение:
Возможно в папке C:Program FilesMicrosoft SQL ServerMSSQL10_50.SQLEXPRESSMSSQLDATA нет необходимых файлов. Необходимо добавить с заменой файлы из папки C:Program FilesMicrosoft SQL ServerMSSQL10_50.SQLEXPRESSMSSQLTemplateData.

Код ошибки 3417

Решение:

Перед заменой файлов рекомендуется сохранить копию папки Data в отдельной директории.

Cкопировать данные из C:Program FilesMicrosoft SQL ServerMSSQLXXXMSSQLTemplate Data в C:Program FilesMicrosoft SQL ServerMSSQLXXXMSSQLDATA

Для 64-разрядных систем — C:Program Files (x86)Microsoft SQL ServerMSSQLXXXMSSQLTemplate Data в C:Program Files (x86)Microsoft SQL ServerMSSQLXXXMSSQLDATA

Если замена файлов не помогла, необходимо дать права на папку Microsoft SQL Server.

Код ошибки 17058

Решение:

Необходимо дать полные права на папки C:Program FilesMicrosoft SQL Server и C:Program Files (x86)Microsoft SQL Server. Если данное решение не поможет — в свойствах службы на вкладке Вход в систему поставьте флаг С системной учетной записью.

Код ошибки 17113

Решение:

Перед заменой файлов рекомендуется сохранить копию папки Data в отдельной директории.

Cкопировать данные из C:Program FilesMicrosoft SQL ServerMSSQLXXXMSSQLTemplate Data в C:Program FilesMicrosoft SQL ServerMSSQLXXXMSSQLDATA

Источник
  • Remove From My Forums

  • Question

  • I am running into a strange error while trying to perform a master database restore.

    While trying to start the Server in Single user mode I get a error 17113, the Server stas in multi user mode as expected, but using the command line

    sqlservr.exe –m –s SERVERSQL1 I get the Empty message box, setting single user mode -m in the  Startup Parameters for SQL Server also fails with the following message in the sql log

    2013-04-12 18:33:47.46 Server      Registry startup parameters:

      -m  -dE:SQL_DataSQL1MSSQL10_50.SQL1MSSQLDATAmaster.mdf
      -e E:SQL_DataSQL1MSSQL10_50.SQL1MSSQLLogERRORLOG
      -l E:SQL_DataSQL1MSSQL10_50.SQL1MSSQLDATAmastlog.ldf
    2013-04-12 18:33:47.46 Server      Error: 17113, Severity: 16, State: 1.
    2013-04-12 18:33:47.46 Server      Error 3(failed to retrieve text for this error. Reason: 15100) occurred while opening file ‘master.mdf’ to obtain configuration information at startup. An invalid startup option might have caused the
    error. Verify your startup options, and correct or remove them if necessary.

    The -f option gives similar behaviour, the SQL Server is a fresh install over a previouly uninstalled SQL Server.

Answers

  • The registry startup parameters are sensitive to extra spaces, and so the reported parameters in the log are not necessarily the ones you are actually using. And the UI for setting them before SQL 2012 is horrible and allowed you to insert hard-to-find
    extraneous spaces.

    To start the SQL Service in single user mode, but not in the console window use the /m switch on NET START:

        net start mssqlserver /m

    You can also restrict the client app name to ensure that you can be the one user:

       net start mssqlserver /mSQLCMD

    Will start the service in single user mode, and only accept connections from the SQLCMD program.

    David

    David http://blogs.msdn.com/b/dbrowne/

    • Proposed as answer by

      Friday, April 12, 2013 3:55 PM

    • Edited by
      davidbaxterbrowneMicrosoft employee
      Friday, April 12, 2013 3:56 PM
    • Marked as answer by
      Olaf HelperMVP
      Saturday, April 20, 2013 4:38 PM

  • *  -dE:*SQL_DataSQL1MSSQL10_50.SQL1MSSQLDATAmaster.mdf

    *  -d E:*SQL_DataSQL1MSSQL10_50.SQL1MSSQLDATAmaster.mdf

    The only difference I see is in the log: A (missing) space Parameter -d and the file Name; but even with this it should work. Very strange.

    No, that is the very issue. When you see something like that in the SQL Server error log, you know that the option is not interpreted as intended. This is how it looks in the errorlog on my instance:

    2013-04-12 23:52:50.97 Server      Registry startup parameters:

        -m
        -d C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATAmaster.mdf
        -e C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLLogERRORLOG
        -l C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATAmastlog.ldf

    Note that every option is on its own line. David did something wrong when he entered the -m option. Maybe he forgot to add a semicolon to the option, so that -d and everthing that follows it became an argument to -m and then it went downhill from there.

    The dialog for adding startup parameters in SQL 2005 and SQL 2008 is very error-prone as you easily can miss a semicolon, and a space too many or whatever. And reading the full string is difficult. Thankfully, the SQL 2012 Configuration Manager, there is
    a dialog similar to what we had in SQL 2000.

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    • Marked as answer by
      Olaf HelperMVP
      Saturday, April 20, 2013 4:38 PM

Источник
  • Remove From My Forums

  • Question

  • I am running into a strange error while trying to perform a master database restore.

    While trying to start the Server in Single user mode I get a error 17113, the Server stas in multi user mode as expected, but using the command line

    sqlservr.exe –m –s SERVERSQL1 I get the Empty message box, setting single user mode -m in the  Startup Parameters for SQL Server also fails with the following message in the sql log

    2013-04-12 18:33:47.46 Server      Registry startup parameters:

      -m  -dE:SQL_DataSQL1MSSQL10_50.SQL1MSSQLDATAmaster.mdf
      -e E:SQL_DataSQL1MSSQL10_50.SQL1MSSQLLogERRORLOG
      -l E:SQL_DataSQL1MSSQL10_50.SQL1MSSQLDATAmastlog.ldf
    2013-04-12 18:33:47.46 Server      Error: 17113, Severity: 16, State: 1.
    2013-04-12 18:33:47.46 Server      Error 3(failed to retrieve text for this error. Reason: 15100) occurred while opening file ‘master.mdf’ to obtain configuration information at startup. An invalid startup option might have caused the
    error. Verify your startup options, and correct or remove them if necessary.

    The -f option gives similar behaviour, the SQL Server is a fresh install over a previouly uninstalled SQL Server.

Answers

  • The registry startup parameters are sensitive to extra spaces, and so the reported parameters in the log are not necessarily the ones you are actually using. And the UI for setting them before SQL 2012 is horrible and allowed you to insert hard-to-find
    extraneous spaces.

    To start the SQL Service in single user mode, but not in the console window use the /m switch on NET START:

        net start mssqlserver /m

    You can also restrict the client app name to ensure that you can be the one user:

       net start mssqlserver /mSQLCMD

    Will start the service in single user mode, and only accept connections from the SQLCMD program.

    David

    David http://blogs.msdn.com/b/dbrowne/

    • Proposed as answer by

      Friday, April 12, 2013 3:55 PM

    • Edited by
      davidbaxterbrowneMicrosoft employee
      Friday, April 12, 2013 3:56 PM
    • Marked as answer by
      Olaf HelperMVP
      Saturday, April 20, 2013 4:38 PM

  • *  -dE:*SQL_DataSQL1MSSQL10_50.SQL1MSSQLDATAmaster.mdf

    *  -d E:*SQL_DataSQL1MSSQL10_50.SQL1MSSQLDATAmaster.mdf

    The only difference I see is in the log: A (missing) space Parameter -d and the file Name; but even with this it should work. Very strange.

    No, that is the very issue. When you see something like that in the SQL Server error log, you know that the option is not interpreted as intended. This is how it looks in the errorlog on my instance:

    2013-04-12 23:52:50.97 Server      Registry startup parameters:

        -m
        -d C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATAmaster.mdf
        -e C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLLogERRORLOG
        -l C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATAmastlog.ldf

    Note that every option is on its own line. David did something wrong when he entered the -m option. Maybe he forgot to add a semicolon to the option, so that -d and everthing that follows it became an argument to -m and then it went downhill from there.

    The dialog for adding startup parameters in SQL 2005 and SQL 2008 is very error-prone as you easily can miss a semicolon, and a space too many or whatever. And reading the full string is difficult. Thankfully, the SQL 2012 Configuration Manager, there is
    a dialog similar to what we had in SQL 2000.

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    • Marked as answer by
      Olaf HelperMVP
      Saturday, April 20, 2013 4:38 PM

Источник

Relocating SQL 2008 Std server running on Win2003 Server.  Server renamed, drives remapped onto new SAN.

Service account is a Machine admin, and said account has full control of every drive letter in the machine.

Startup parameters were modified to read:
-eD:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLLogERRORLOG; -dE:SQLmaster.mdf; -lL:SQLmastlog.ldf

All paths are valid and I checked the permissions.

Doing a plain old NET START MSSQLSERVER yields an error 17113 with this detail:

«Error 3(The system cannot find the path specified.) occurred while opening file ‘master.mdf’ to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.»

master.mdf is in the listed folder.  I even matched the case of every letter in the path.  Still 17113.

NOW HERE IS the RUB!

If I do this:
net start mssqlserver  /dE:SQLmaster.mdf /lL:SQLmastlog.ldf

everything starts normally.

No idea of my error.  The parameters in Config manager look perfect.

Please assist.  Production servers depend upon this.

Thanks
John

Источник

Hi,

I have restored a server from backup- this is a single server for a primary school that serves as DC, DNS, DHCP, SQL etc.

I have just about got everything up and running, however I can’t get the SQL database up and running. The services don’t start, I get the bellow error:

[quote]

Services

Windows could not start the SQL Server (servername) on local computer. For more information, review the system event log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 17113.

[/quote]

I have done a quick Google and all I can find is when restoring a DC, it changes the service to log on with the local system account. I have tried changing this to some of the administrator accounts but it still won’t start.

Any ideas?

Regards,

Dan

Источник

Понравилась статья? Поделить с друзьями:
  • Не удалось запустить службу sql server код ошибки 17051
  • Не удалось запустить службу sql server код ошибки 1069
  • Не удалось запустить службу sql server код ошибки 1067
  • Не удалось запустить службу sbis3plugin ошибка 1053
  • Не удалось запустить службу mysql ошибка 1067