SQL Prompt Installed issues

SmartFei

I 'm trying too install SQL Prompt, but the progress bar hangs once it gets to "Service: Redgate Client". Eventually it returns this error:

Product: SQL Prompt 9 -- Error 1920. Service 'Redgate Client' (RedGateClient) failed to start. Verify that you have sufficient privileges to start system services.

My account is administrators,isuper power.

OS  win10 1803

The error has to do with starting the Redgate Client service. 

Can we provide an effective solution?

RichardL

Hi @SmartFei

Thanks for your post. 

Below is the latest version if you haven't already installed this one. 
ftp://support.red-gate.com/patches/SQLPrompt/13Jun2018/SQLPrompt_9.1.16.5356.exe

Also, are you meeting the minimum system requirements for SQL Prompt? These are listed in the link below for you. 
https://documentation.red-gate.com/sp9/requirements

I hope this gets you up and running. 

Kind regards

Richard Lynch. 

SmartFei

hi,@richardL

yes, i have minimum system requirements for SQL Prompt.

The os is .net Framework 4.7,

I installed it with the latest version，still appear this issue.

Product: SQL Prompt 9 -- Error 1920. Service 'Redgate Client' (RedGateClient) failed to start. Verify that you have sufficient privileges to start system services.

AAltemus

I'm seeing the same.  Windows 10, .NET 4.7, SQL Server 2017, SQL Server Management Studio 2017. I've tried an uninstall and reinstall and still see the same thing. 

AAltemus

I also verified that the 8.2 installer will install fine. 

RichardL

Hi @AAltemus

Thanks for your post. 

It looks like the install is failing on the Redgate client service so could you try installing this by itself and then installing Prompt.

The first thing you'll need to do is extract the .msi from the .exe

There's instructions on how to do this through the link below:
https://documentation.red-gate.com/xx/installing/installing-from-the-msi-file

Once extracted could you then run through the following steps:

Clear out the following directories:
a. Clear all temp directories
b. Clear C:\ProgramData\Downloaded Installations
c. Clear C:\ProgramData\Red Gate
d. Clear C:\Program Files (x86)\Common Files\Red Gate\Shared Client\

Copy the extracted C:\Redgate installers\**Redgate Product**\Red Gate\Shared Client folder to C:\Program Files (x86)\Common Files\Red Gate\Shared Client\

Add the service by running "C:\Windows\Microsoft.NET\Framework\v4.0.30319\InstallUtil.exe" "C:\Program Files (x86)\Common Files\Red Gate\Shared Client\RedGate.Client.Service.exe"

Start the service manually and check http://127.0.0.1:22221/redgate/status to see if it shows you the Redgate Client page

Start the installer as an administrator and rerun it.

I hope this helps. 

Kind regards

Richard Lynch. 

TheoL

I am now having the same symptom with update 9.4.7.7595.  "The bug is back!"
Win 10 x64 - latest updates.

l_millerm

I encountered this issue on my previous machine running Windows 7 and I've been fighting with this one for several hours after upgrading to Windows 10 1709 and ultimately I forgot what I did to get it to work... Frustrating!

TL;DR:

First run this from an elevated command/powershell terminal to see what's available:

netsh http show iplisten

If you don't have 127.0.0.1 and/or ::1 in there, then run these commands to add them:

netsh http add iplisten 127.0.0.1

Then try running the service and/or installing. 

So, after taking a deeper look into the logs and trying to run several verions of RedGate.Client.Service.exe directly, looking at some OWIN & Windows networking docs I ended up trying a few netsh commands in an elevated cmd/powershell terminal and it worked!

From the docs: Network shell (netsh) is a command-line utility that allows you to configure and display the status of various network communications server roles and components after they are installed on computers running Windows Server 2016. More specifically Netsh commands for HTTP context to query and configure HTTP.sys settings and parameters.

So to do that, let's first run this to see what's available:

netsh http show iplisten

If you don't have 127.0.0.1 and/or ::1 in there, then run these commands to add them:

netsh http add iplisten 127.0.0.1

Then try running the service and/or installing.  This worked for me.

@RedGate Support I would recommend updating the installer to check for this situation and add configure the network settings via netsh as needed.

l_millerm

I encountered this issue on my previous machine running Windows 7 and I've been fighting with this one for several hours after upgrading to Windows 10 1709 and ultimately I forgot what I did to get it to work... Frustrating!

TL;DR:

First run this to see what's available:

netsh http show iplisten

If you don't have 127.0.0.1 and/or ::1 in there, then run these commands to add them:

netsh http add iplisten 127.0.0.1

Then try running the service and/or installing. 

So, after taking a deeper look into the logs and trying to run several verions of RedGate.Client.Service.exe directly, looking at some OWIN & Windows networking docs I ended up trying a few netsh commands in an elevated cmd/powershell terminal and it worked!

From the docs: Network shell (netsh) is a command-line utility that allows you to configure and display the status of various network communications server roles and components after they are installed on computers running Windows Server 2016. More specifically Netsh commands for HTTP context to query and configure HTTP.sys settings and parameters.

So to do that, let's first run this to see what's available:

netsh http show iplisten

If you don't have 127.0.0.1 and/or ::1 in there, then run these commands to add them:

netsh http add iplisten 127.0.0.1

Then try running the service and/or installing.  This worked for me.

@RedGate Support, I would recommend that you check this configuration as part of the install process and adjust it accordingly.  I resolved this months ago and have lost a considerable amount of time and frustration trying to recall what I did to ultimately resolve the issue.

l_millerm

I encountered this issue on my previous machine running Windows 7 and I've been fighting with this one for several hours after upgrading to Windows 10 1709 and ultimately I forgot what I did to get it to work... Frustrating!

TL;DR:

First run this to see what's available:

netsh http show iplisten

If you don't have 127.0.0.1 and/or ::1 in there, then run these commands to add them:

netsh http add iplisten 127.0.0.1

Then try running the service and/or installing. 

So, after taking a deeper look into the logs and trying to run several verions of RedGate.Client.Service.exe directly, looking at some OWIN & Windows networking docs I ended up trying a few netsh commands in an elevated cmd/powershell terminal and it worked!

From the docs: Network shell (netsh) is a command-line utility that allows you to configure and display the status of various network communications server roles and components after they are installed on computers running Windows Server 2016. More specifically Netsh commands for HTTP context to query and configure HTTP.sys settings and parameters.

So to do that, let's first run this to see what's available:

netsh http show iplisten

If you don't have 127.0.0.1 and/or ::1 in there, then run these commands to add them:

netsh http add iplisten 127.0.0.1

Then try running the service and/or installing.  This worked for me.

@RedGate Support, I would recommend that you check this configuration as part of the install process and adjust it accordingly.  I resolved this months ago and have lost a considerable amount of time and frustration trying to recall what I did to ultimately resolve the issue.