patchmypc.com Open in urlscan Pro
2606:4700:10::ac43:75c  Public Scan

Form analysis
1 forms found in the DOM

GET https://patchmypc.com/

<form role="search" method="get" class="et_pb_menu__search-form" action="https://patchmypc.com/">
  <input type="search" class="et_pb_menu__search-input" placeholder="Search …" name="s" title="Search for:">
</form>

Text Content



MEM INTEGRATION


Overview
Customer Reviews
FAQs
Pricing
Supported Products
Setup Documentation


NEXT STEPS?

Schedule Live Demo

Free Trial
×


LEARN MORE


FAQs
Knowledge Base
Support Forum
Catalog Release History
Feature Requests
Partners & Resellers


GETTING STARTED


30-Day Free Trial
Schedule Live Demo
Schedule Setup Call
Setup Documentation
Release Notes
Product Roadmap


ENTERPRISE SUPPORT

Open Support Case

Schedule Review Call
×


COMPANY


About Us
Careers
Our History
Our Values
Meet Our Team


LEARN MORE?

Contact Us
×

 CALL US: 1-800-250-2334

 REQUEST QUOTE    FREE TRIAL      SCHEDULE DEMO


 * Enterprises3
 * Resources3
 * Home Users
 * Company3

 * Enterprises3
 * Resources3
 * Home Users
 * Company3




KNOWLEDGE BASE

We’re here to help if needed

Catalog Releases
Open Support Case


DESCRIPTION

This article will show you how the Patch My PC Publisher can be set up to
publish updates in a standalone WSUS environment.

Topics discussed in this article:

 * Configuring Standalone WSUS Mode
 * Enable Standalone WSUS Mode
 * Verify Third-Part Updates appear in the WSUS Console
 * SQL permissions required to publish update information to the database


CONFIGURING STANDALONE WSUS MODE

You can publish third-party updates to standalone WSUS without SCCM. To allow
updates to appear directly in WSUS, follow the instructions in this article.

Standalone WSUS mode is only required when you are not using Configuration
Manager for software updates and are only using WSUS. When enabled, published
third-party updates will appear directly in the WSUS console.


ENABLE STANDALONE WSUS MODE

To enable standalone WSUS mode, go to the Updates tab and select Options. In
the WSUS options window check the box Make updates appear in the WSUS console.
This option isn’t needed if using Configuration Manager.



If your WSUS database is using a Windows Internal Database (WID), the database
connection options will be read-only.

When using a SQL Server for the WSUS database, you will need to choose either to
connect to the database using the SYSTEM account or define a user name and
password using SQL authentication.




VERIFY THIRD-PARTY UPDATES APPEAR IN THE WSUS CONSOLE

Any updates published after this setting was enabled should appear directly in
the WSUS console.



You can now deploy the third-party updates just like a Microsoft update directly
from the WSUS console.

If updates were published before this setting was enabled, they would not appear
in the WSUS console automatically.

For updates published before WSUS Standalone mode was enabled, use the Modify
Published Updates Wizard to make those updates appear in the WSUS console.


SQL PERMISSIONS REQUIRED TO PUBLISH UPDATE INFORMATION TO THE DATABASE

When the Patch My PC Publishing Sync runs, if the SUSDB is remote from the WSUS
Standalone server, you would have to grant specific permissions to the computer
account where PMPC is installed for it to be able to update information.

The script below can be used to grant those permissions. Make sure to replace
the computer account values with the ones appropriate to your environment.

The code can be edited, and run as a SQL query to grant the permissions.


h

SQL

USE SUSDB
GO

— Replace CONTOSO\ServerName$ with the appropriate value for your environment
DECLARE @UserName nvarchar(128) = ‘CONTOSO\ServerName$’

DECLARE @QuotedUserToGrant nvarchar(128) = QUOTENAME(@UserName);

IF NOT EXISTS(SELECT principal_id FROM sys.server_principals WHERE name =
@UserName) BEGIN
DECLARE @LoginSQL as varchar(500);
SET @LoginSQL = ‘CREATE LOGIN ‘+ @QuotedUserToGrant + ‘ FROM WINDOWS’;
EXEC (@LoginSQL);
END

IF NOT EXISTS(SELECT principal_id FROM sys.database_principals WHERE name =
@UserName) BEGIN
DECLARE @UserSQL as varchar(500);
SET @UserSQL = ‘CREATE USER ‘ + @QuotedUserToGrant + ‘ FOR LOGIN ‘ +
@QuotedUserToGrant;
EXEC (@UserSQL);
END

DECLARE @PermissionsSQL as varchar(500);
SET @PermissionsSQL = ‘GRANT UPDATE ON [dbo].[tbUpdate] ([IsLocallyPublished])
TO ‘ + @QuotedUserToGrant +
‘GRANT SELECT ON [dbo].[tbUpdate] ([UpdateID]) TO ‘ + @QuotedUserToGrant;
EXEC (@PermissionsSQL);


 * Follow
 * Follow
 * Follow
 * Follow
 * Follow
 * Follow



Product

Patch Management

Application Management

Supported Products

Pricing

FAQs

Getting Started

Free Trial

Schedule a Live Demo

Schedule a Setup Call

Schedule a Q&A Session

Partners & Resellers 

Download & Docs

Resources

About

Customer Reviews 

Forum

Support

Knowledge Base

Security Information

Contact & Privacy

Call Us: 1-800-250-2334

Contact Us

sales@patchmypc.com

support@patchmypc.com

Terms of Service 

Privacy Policy