Saturday, October 24, 2015

SCUP 2011 Integrate with SCCM 2012 R2

Couple of days back got some third party updates you wish to publish and deploy to your environment with ConfigMgr 2012? A great way to do it is with SCUP 2011 integrated into ConfigMgr 2012.
I had some issue and not able to resolve that, but after some troubleshooting I found the way to resolve that. 
Resolution:
Please note this guide assumes that you are familiar with ConfigMgr 2012, Windows Server 2012, WSUS for Server 2012 and already have WSUS and ConfigMgr 2012 installed with a Software Update Point Role
References:
Download SCUP 2011: http://www.microsoft.com/en-us/download/details.aspx?id=11940
Server 2012 Create Self-signed Cert button workaround: http://blogs.technet.com/b/wsus/archive/2013/08/15/wsus-no-longer-issues-self-signed-certificates.aspx
Publishing Updates to WSUS on Windows 2012: https://technet.microsoft.com/en-us/library/hh134747.aspx#PublishToServer2012
Steps:
(If you already have SCUP 2011 installed and want to re-install add these steps):
1. Uninstall SCUP from the Server
2. Do a search on the server for all entries of "scupdb.sdf"
3. Delete all entries found for the "scupdb.sdf"
4. Reboot the server

Install:
1. Using the ConfigMgr 2012 Admin Account, login to the server
2. Open command prompt with Administrator Privileges(Right click and select Open as Admin), install SCUP 2011
3. Assure the "scupdb.sdf" was created under the following path:
'C:\Users\<ConfigMgr 2012 Admin Account>\AppData\Local\Microsoft\System Center Updates Publisher 2011\5.00.1727.0000'
4. Open Regedit, Navigate to "HKEY_LOCAL_MACHINE\Software\Microsoft\Update Services\Server\Setup\"
4.1 Create DWORD value: EnableSelfSignedCertificates = 1
5. Open Regedit, Navigate to "HKEY_CLASSES_ROOT\AppID\{8F5D3447-9CCE-455C-BAEF-55D42420143B}"
5.1 Click Edit, click Permissions and then click Advanced
5.2 Click Change owner to, specify Administrators and then click OK
5.3 Specify Full Control permissions for Administrators and SYSTEM.
5.4 Close Regedit
5.5 Open command prompt with Administrator Privileges(Right click and select Open as Admin), type Dcomcnfg.exe and press ENTER
5.6 Expand Component Services, expand Computer, Expand My Computer, Expand DCOM Config, right click WSUSCertServer and click Properties
5.7 Select the Security Tab and configure the following permissions
5.8 Launch and Activation: Select Allow for the Local Launch and Local Activation permissions
5.9 Access Permission: Select Allow for the Local Access permission
6. Restart the WSUSCertServer process:
6.1 Open command prompt with Administrator Privileges(Right click and select Open as Admin)
6.2 net stop wsuscertserver and press ENTER
6.3 net start wsuscertserver and press ENTER

Configure:
1. Using the ConfigMgr 2012 Admin Account, login to the server
2. Open the SCUP 2011 Console by right clicking and selecting Run As Administrator, choose "Options"
3. Click the Update Server Tab
3.1 Check Enable publishing to an update server
3.2 Select the Connect to a local Update Server
3.3 Click the Signing Certificate Create button, complete the wizard
(This should work now due to the work around done in the install steps)
3.4 Click the Test Connection button
3.5 You should see the information for the Certificate issues below the Create button now
4. Click the ConfigMgr Server Tab
4.1 Check Enabled Configuration Manager Integration
4.2 Choose local or remote ConfigMgr server accordingly
4.3 Click the Test Connection button

Get Certificate to distribute:
1. Using the ConfigMgr 2012 Admin Account, login to the server
2. Open the MMC
3. Click File, then Add \ Remove Snap-In
4. Click Certificates and then Add
5. Select Computer Account and then Next
6. Select Local Computer and then Finish
7. On the Add or Remove Snap-ins, click OK
8. Navigate to WSUS Certificate Store, right click the certificate and choose all tasks, then export
8.1 On the Export Private Key, choose No, do not export the private key and then click Next
8.2 On the Export File Format, select DER encoded binary x.509 (.CER) and then click Next
8.3 On the File to Export, Type C:\wsuscert.cer and then click Next
8.4 Click Finish and then OK

Publish to TrustedPublisher and Root:
1. Using the ConfigMgr 2012 Admin Account, login to the server
2. Open command prompt with Administrator Privileges(Right click and select Open as Admin)
3. type:
3.1 certutil.exe -addstore TrustedPublisher C:\wsuscert.cer (press ENTER)
3.2 certutil.exe -addstore root C:\wsuscert.cer (press ENTER)
4. Distribute the Cert out to all workstations in the environment via GPO as well.
Domain Policy Change:
You need to make sure this is enabled, to allow 3rd party updates to be installed when found on a intranet Microsoft Update Service aka WSUS \ ConfigMgr, for all clients you intend to deploy the 3rd party updates to.
Assure is that the Policy also has the “Allow Signed Updates from an Intranet Microsoft Update Service Location” to be enabled.
You find this setting under the group policy editor in the following path:
Computer Configuration \ Administrative Templates \ Windows Components \ Windows Update

Thanks to 

Charles Allen’s Blog

Wednesday, December 31, 2014

OS deployment fails (Failed to download policy )


Recently I have faced an issue with OS deployment. While OSD I got an error

While checking the smsts.log file I found the error in log file that was showing

BOM not found on policy reply

Failed to download policy {172A41CC-19A7-4BE3-91BC-0D979432CA10}/9 (Code 0x80004005).
 
 
 
I checked multiple things but nothing has worked.  Checked the package versions, scope IDs in application but everything was fine.
After that I searched the Policy in the SCCM database in table policyassignment and Policy
select * from policyassignment where policyid = '{172A41CC-19A7-4BE3-91BC-0D979432CA10}/9'
select * from policy where policyid = '{172A41CC-19A7-4BE3-91BC-0D979432CA10}/9'
 
after that I have deleted the policy which was showing as error in smsts.log file.
Delete from policyassignment where policyid = '{172A41CC-19A7-4BE3-91BC-0D979432CA10}/9'

Monday, April 21, 2014

Error while doing Prestage file on Sec Site/DP ExtractContent failed; 0x80040e09

I had an error while doing extract the prestage file on Sec Site


Above error was showing failed to execute the query to register content of package.
When I was checking everything was fine from DP site and as well as from Primary site.

Then again I checked the SQL permission on database, then found we have to grant the permission on service account in SQL server, which has been used for SQL server and Sec site/DP installation.

Then I provided the full permission on Service account then I was success



Saturday, February 22, 2014

The collation of the site database does not match the collation of the parent site's database

I had SQL error at the Prerequisite Check page regarding the required SQL Server Collation:

"The collation of the site database does not match the collation of the parent site's database.  All sites in a hierarchy must use the same database collation.in SCCM 2012"


Configuration Manager required that you configure your SQL Server instance and Configuration Manager Site database (if already present) to use the SQL_Latin1_General_CP1_CI_AScollation,





The server collation is specified during SQL Server installation.  So this means that you need to re-install the SQL server or rebuild your database.  The server collation acts as the default collation for all system databases that are installed with the instance of SQL Server, and also any newly created user databases.
It is highly recommend to do this only on a SQL which is not in use by any other application!
Navigate to your SQL setup folder or DVD where the setup.exe is located and execute the underneath command:
Setup.exe /QUIET /ACTION=REBUILDDATABASE  /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=BUILTIN\Administrators


Sunday, February 16, 2014

List of errors code during the client installation

– The system cannot find the file specified.
5 – Access denied.
52 – You were not connected because a duplicate name exists on the network. Make sure there is not a duplicate name in DNS and that 2 machines don’t have the same IP in DNS.
53 – Unable to locate, cannot connect to admin$ – Computer Browser not started 
58 – The specified server cannot perform The requested operation
64 – The specified network name is no longer available. Source: Windows
67 – network name cannot be found.
86 – network password is not correct? Machine Name <> resolved name.
112 – Not enough disk space
120– Mobile client on the target machine has the same version, and ‘forced’ flag is not turned on. Not processing this CCR ,target machine already have cm client and no force install selected(always install).
1003 – Cannot complete this function.
1053 – The service did not respond to the start or control request in a timely fashion.
1068 – The dependency service or group failed to start
1130 – Not enough server storage is available to process this command. Source: Windows
1203 – The network path was either typed incorrectly, does not exist, or the network provider is not currently available. Please try retyping the path or contact your network administrator.
1208 – An extended error has occurred. Source: Windows
1305 – The revision level is unknown.
1396 – Logon Failure: The target account name is incorrect. (NBTSTAT -a reverse lookup, duplicate IP address)
1450 – Insufficient system resources exist to complete the requested service. Source: Windows
1789 – The trust relationship between this workstation and the primary domain failed.
2147749889 – Generic WMI failure (Broken WMI)
2147749890 – not found – Source: Windows Management (WMI) – try repair WMI
2147749904 – Invalid class – Source: Windows Management (WMI)
2147749908 – Initialization failure – Source: Windows Management (WMI)
2147942405 – Access is Denied (Firewall rule? / MacAfee-HIPS?)
2147944122 – The RPC server is unavailable. 

2148007941 – Server Execution Failed

Friday, January 31, 2014

Improve SCCM console performance

We can improve SCCM 2012 Console performance by using of SQL server, we will have to configure a setting known as Maximum Degree of Parallelism or MAXDOP for short. When SQL Server runs on a computer with more than one CPU, it detects the best degree of parallelism, the number of processors employed to run a single statement, for each parallel plan execution. This means that multiple queries may be executed. Setting the MAXDOP setting to the optimal setting can help improve performance by setting the limit to the number of physical processors.


We will use SQL to configure this value by using SQL Management Studio using the following steps:
1) In the object explorer, right click a server and select Properties.



 2)      Click the Advanced node.








      3) In the Max Degree of Parallelism box, select the maximum number of processors to use in parallel plan execution.
The default value of 0 uses all available processors. Set max degree of parallelism to 1 to suppress parallel plan generation. Set the value to a number greater than 1 to restrict the maximum number of processors used by a single parallel query execution. If a value greater than the number of available processors is specified, the actual number of available processors is used. If the computer has only one processor, the max degree of parallelism value is ignored.

Friday, January 3, 2014

Improve the performance of PXE boot


To improve the PXE boot we have to enable/add a registry value in DP where PXE is enabled,

From the distribution point (where you enabled PXE) complete the following

1.        Open regedit and locate HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\DP

2.        Add a QWORD value and call it RamDiskTFTPBlockSize

3.        Give it a Hexadecimal value of “4000″

PXE Issue after SCCM CB 1806 upgrade

Recently i had upgraded my SCCM environment 1806 and after upgrade suddenly all PXE servers stopped working. While initiating the PXE ...