SQL Install: Bypass the “Restart computer” setup support rule

Need to add a feature or something on SQL but you cant’ because there is a restart pending? Well let me show you how.

Before proceeding you need to understand that you might just break something, there is a reason your computer wants to restart. If there was a SQL update and you are making changes before the restart you might just cause something detrimental, or you might not. But you are a SQL expert ,so no issues there.

This is the issue in question.


image

There is only 1 way to bypass this:

*Please note that using this method might potentially result in an unsupported installation – Thanks to David A Whitney Sr for pointing that one out*

We will be using command prompt, you can also use PowerShell, but this is a normal CMD. The source of this is How to: Install SQL Server 2008 from the Command Prompt, which is always great reading.

Open Command prompt and navigate to your SQL Server media. Then you will run a command that looks something like this:


Setup.exe /ACTION=Install /FEATURES=SQL,Tools /INSTANCENAME=MSSQLSERVER /SkipRules=RebootRequiredCheck

Note the /SkipRules=RebootRequiredCheck this will force SQL to bypass the check.


image

When running this you will get the SQL installation prompt come up and you proceed as normal.


image

Note: If the restart pending is an error you are encountering even after restarts there is a registry fix that will help, just search for HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager online and you will find more information.

#2008 #2012

0 views0 comments

Recent Posts

See All

SQL transfer changes between 2 tables, mini-replication

I have 2 identical SQL servers, with identical I refer to schema and not data. What I need to do is get the same data in both. This is simple replication and would imply pulling the data from Table 1