Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Setup service did not respond to the start or control request in a timely fashion error when installing SQL Server 2016

How can I resolve the error I received when installing Microsoft SQL Server 2016?

TITLE: Microsoft SQL Server 2016 Setup service did not respond to the start or control request in a timely fashion

The following error has occurred:

The service did not respond to the start or control request in a timely fashion.

Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.1601.5&EvtType=0xDC112D1C%25400xDC80C325


BUTTONS:

&Retry

Cancel

like image 275
Tarzan Avatar asked Jun 01 '16 22:06

Tarzan


1 Answers

Add the SQLRUserGroup to "Allow log on locally".

enter image description here

If you can't change Group Policy, temporarily add the MSSQLServer01 to MSSQLServer20 users to the local administrator group.

Click Re-try on the SQL Install and use the Log to confirm all MSSQLServer<ID> users are admins.

C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log\ExtensibilityLog\EXTLAUNCHERRORLOG

The error in the log file is:

LogonUser Failed for user MSSQLSERVER01. ErrorCode: 0x80070569.

When all MSSQLServer1-20 have access the installation will complete.

like image 141
Jeremy Thompson Avatar answered Nov 04 '22 11:11

Jeremy Thompson