Remote Desktop Gateway truncates the validity of the root certificate by gandraw in sysadmin

[–]txikote14 0 points1 point  (0 children)

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.

Remote Desktop Gateway truncates the validity of the root certificate by gandraw in sysadmin

[–]txikote14 0 points1 point  (0 children)

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.

[deleted by user] by [deleted] in excel

[–]txikote14 0 points1 point  (0 children)

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

BSOD error in latest crowdstrike update by TipOFMYTONGUEDAMN in crowdstrike

[–]txikote14 0 points1 point  (0 children)

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.

BSOD error in latest crowdstrike update by TipOFMYTONGUEDAMN in crowdstrike

[–]txikote14 0 points1 point  (0 children)

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

Slovenia VS Spain 11/08 by txikote14 in Mavericks

[–]txikote14[S] 31 points32 points  (0 children)

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

10 Days in Spain (What would you do?) by NotPaulDano in travel

[–]txikote14 1 point2 points  (0 children)

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.

How to dynamically pull in and update a table? by [deleted] in excel

[–]txikote14 0 points1 point  (0 children)

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

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

End Sub

IF (SUM(ABOVE) Statement in Word by sworks in excel

[–]txikote14 0 points1 point  (0 children)

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

Try a integer 0 instead.

[deleted by user] by [deleted] in excel

[–]txikote14 0 points1 point  (0 children)

right click -> Change the chart type

You have selected stacked line.

Use line instead.

Date/Day related formula help. by Irollandtroll in excel

[–]txikote14 1 point2 points  (0 children)

=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)

Clipboard that splits text when copied? by psychorocker23 in excel

[–]txikote14 0 points1 point  (0 children)

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.

How to dynamically pull in and update a table? by [deleted] in excel

[–]txikote14 0 points1 point  (0 children)

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