Lorky

Limit WSUS memory usage with HeidiSQL

July 27, 2022, 2:30 pm technology

Hi everyone

Today I wanted to share a tip if your WSUS database (SQL) is eating too much resource on your server.

Like shown there;

image-1.png?w=457

or there too;

image-2.png?w=536

There is multiple way to do it, but I wanted to share a simple way to do it without any native SQL tool installed. For that reason I used HeidiSQL portable edition.

image-3.png?w=873

After it's open, you need to select a named pipe;

image-4.png?w=640

Click to use windows authentication, and in the database path please put;

\\.\pipe\Microsoft##WID\tsql\query (Windows Server 2012 +)
or
\\.\pipe\mssql\$microsoft##ssee\sql\query (pre 2012)

It would look that way;

image-5.png?w=606

After that you it the Request tab, and you enter;

image-6.png?w=829

You can check the configuration;

image-7.png?w=597

After you issue the last command to set the memory you want it to use;

image-8.png?w=702

In my example I used 512, but I recommend 1024+ in the minimum.

To resume, it would be those command we used;

exec sp_configure 'show advanced option', '1';

reconfigure;

exec sp_configure;

exec sp_configure 'max server memory', 2048;

reconfigure with override;

Windows Store Error - Firewall

July 11, 2022, 4:01 pm technology

Hi everyone

Today I wanted to share a tip for any sysadmin can encounter. It's for the Windows Store app and the GPO.

I stumbled into a environment that blocked the Windows Store to work, after multiple test I found that you really need the Windows Firewall at On to be able to restore the Windows Store.

The culprit in my case was a GPO that set at Disabled that settings;

image.png?w=658

It took me time to figure it as the machine was using a third party firewall's solution, so the computer was not alerting me at all that the firewall was missing, and the store app just refused to open without any error.

Older HP Universal Print Driver for GPP

May 31, 2022, 3:59 pm technology

Hi everyone

I wanted to share a small tip if you need older HP Universal Print Driver for your GPP.

You might ask why, it's because in pushed GPO some older drivers work better for older printer to keep their settings, and to work in general.

The treasure groove is there; ftp://ftp.hp.com/pub/softlib/UPD/ :)

image.png?w=428

Enjoy if you need it :)

Edit #1 (2022-12-02)

It got to my attention that the FTP was removed. I setup a small archive repostery here if you ever need some; https://github.com/yagmoth555/older-hp-upd

Keep in mind I just have the 6.4.1.22169 at the moment.

Office 365 TLS 1.2 support

March 15, 2022, 3:58 pm technology

Hi everyone

Today I wanted to talk a small problem I seen on Office 2016, but running on really older OS.. like Windows 7..

Office 365 support for older cryptography maked some older OS get a problem to authenticate, so it block adding a new account or to get the email in Outlook in example.

To fix, I would say, please by god, install Windows 10 .. but if you can't convince your customer, at-least, for now, you can run that tool to get the TLS 1.2 by default in the OS, so it can connect back.

How to enable TLS 1.2 on clients and Update to enable TLS 1.1 and TLS 1.2 as default secure protocols in WinHTTP in Windows

[Easy fix here]

Thanks !, and let hope Windows 7 don't come back so fast

GPO - Per machine Printer Settings

February 28, 2022, 4:54 pm technology

Hi everyone

Today I wanted to share a small script if you use per machine GPO / GPP to distribute local TCP/IP printers to your computers park.

image-7.png?w=267

If like me sometime the settings are not push correctly I did a small script that check the local printer and find the corresponding print queue on the print server to set the options in the computer.

It seemed a need for me in some case depending on which driver I use, as some revert to the basic settings when pushed. The printing's default got ignored in such case.

The script look like that;

$Printers = Get-Printer
Foreach ($Printer in $Printers) { 

$PrintConfig = Get-PrintConfiguration -ComputerName PRINTSERVER -PrinterName $Printer.name
Set-PrintConfiguration -PrinterName $Printer.name -PrintTicketXML $PrintConfig.PrintTicketXML
}

The script loop all locals printer and find the corresponding printer on the print server to set the option.

The script assume you use the same printer name than the one on the print server, which for me was logical because you have to enter a target print queue for publishing the printer.

Lorky`s Blog - Techno ressources and general informations for everyone !

Limit WSUS memory usage with HeidiSQL

Windows Store Error - Firewall

Older HP Universal Print Driver for GPP

Office 365 TLS 1.2 support

GPO - Per machine Printer Settings

Popular Tags

Archives