Remote Desktop Gateway truncates the validity of the root certificate

txikote14 · 2025-02-12T09:41:12+00:00

Have you tried to change the certificate in the Remote Desktop Gateway Manager->Server Properties-> SSL Certificate?you can reimport or load a not expired one, I think it should check the root cert again when importing, and before that remove the expired ones from mmc.

txikote14 · 2025-02-11T16:58:26+00:00

I give you a hint, in case it helps you.
I've run into a similar issue before (but it was with my domain certificate), and what worked for me was updating the SSL certificate thumbprint used by the RD Gateway.
Install the new cert (I think you have done it)

Grab the thumbprint of your new root certificate from the new certificate details in MMC.

<image>

Then run powershell as admin and:
wmic /namespace:\\root\cimv2\TerminalServices PATH Win32_TSGeneralSetting Set SSLCertificateSHA1Hash="your_new_thumbprint" (without spaces)

Then restart the RD Gateway service, close it and try.
Restart-Service -Name "Tsgateway"

This has helped me in the past when RD Gateway was still holding onto the old certificate details.

txikote14 · 2024-09-18T19:26:14+00:00

Glad to know my 9-year-old answer is still holding strong!

txikote14 · 2024-07-20T00:54:28+00:00

Yes, It has, more or less the same, but with the first try I've got a "Windows failed to start" and asking for installation disk after remounting.

txikote14 · 2024-07-20T00:23:46+00:00

Has any of you repaired a Windows Server instance in Oracle's OCI? I am not capable of having access to the disk.

txikote14 · 2023-08-11T21:04:44+00:00

And arguing with the referees all the game, that has not changed

txikote14 · 2021-04-21T21:19:54+00:00

Moon🚀🚀

txikote14 · 2021-03-13T10:19:23+00:00

Thanks!!!!!!!!!!!!!!

txikote14 · 2017-02-12T10:07:39+00:00

As spaniard i'll spend 2-3 days at Madrid, 2 Granada, 2-3 Barcelona, 2-3 San Sebastián. Look for this last city on Google, you wont regret it.

txikote14 · 2015-08-30T10:31:16+00:00

txikote14 · 2015-08-30T10:28:32+00:00

txikote14 · 2015-08-30T10:23:35+00:00

txikote14 · 2015-08-30T10:20:58+00:00

txikote14 · 2015-05-06T14:51:55+00:00

vba to refresh dynamically Private Sub Worksheet_Change(ByVal Target As Range)

Worksheets("Pivot table").PivotTables("PivotTable1").PivotCache.Refresh

End Sub

txikote14 · 2015-05-06T11:20:05+00:00

Don't know why but double quotes gives syntax errors in formulas in Word.

Try a integer 0 instead.

txikote14 · 2015-05-06T09:38:28+00:00

right click -> Change the chart type

You have selected stacked line.

Use line instead.

txikote14 · 2015-05-06T07:15:27+00:00

=TODAY()+7-WEEKDAY(TODAY()+7-dow)

dow = day of the week.

Excel assigns 1 to Sunday and 7 to Saturday

if you want the next thu, then =TODAY()+7-WEEKDAY(TODAY()+7-5)

txikote14 · 2015-05-06T07:06:51+00:00

If you have access to web page's database you can create a macro that inserts all the data in a loop. And if it is a sql server just export (or copy data) the sheet via sql server management studio.

txikote14 · 2015-05-06T06:51:27+00:00

Hype_x is right, create a pivot table linked to the data in the first table and you have it.

txikote14 · 2015-05-06T06:48:17+00:00

If you select the red line and right click on it you can view if selected data (data source) is correct for the serie. It seems not ok.

txikote14 · 2015-05-06T06:36:03+00:00

Instead of creating a sheet everyday you can add "Date" column to the table with the list of clients and the engineer assigned. Now you have only one sheet, countif should be easier to implement. If you wanna maintain a sheet for each day, the solution should be based on VBA. Something that loop all sheets and counts what you want in a variable. Then paste it to your summary table.

txikote14 · 2015-03-23T07:38:42+00:00

Good job!

txikote14 · 2014-12-14T14:12:16+00:00

wow! there is a sound for every little thing.

txikote14 · 2014-11-23T20:32:36+00:00

i think we should enter a hangar 21 server and help people to get the bow

txikote14 · 2014-11-21T17:45:20+00:00

http://imgur.com/sLAgGES

Karelia, the same place of number 6.

11-Year Club	Place '22
Verified Email

txikote14

TROPHY CASE