MSI installation based software

Recently I needed to demonstrate ConfigMgr 2012 R2 Software Center for a client. Of course, I needed some demo *.MSI files to import as applications.

One Twitter message later, and I had lots of great suggestions. (Thank you) I’ve compiled a partial list of the downloads here. In part, it might help someone else, and I’ll likely use this as a future reference.

First the suggestions for Free MSI installers:

From codeplex: DBViewSharp, DiffMerge, Expresso, SharpDevelop, StyleCop, XmlExplorer, XPathVisualizer

From Microsoft: XMLNotepad, ReportBuilder, RDCMan, Skype

Others: 7-Zip, Flash, Tweetdeck, Adobe readers/players, trial software from TechSmith.

Now Micro Right Click Tools

ConfigMgr toolkit, ConfigMgr support center, ConfigMgr client center, FileZilla

ConfigMgr console, ConfigMgr PowerShell library

Download links:

Adobe Downloads

Microsoft® SQL Server® 2012 Report Builder

From <>

Remote Desktop Connection Manager 2.7

From <>

XML Notepad 2007

From <>

TechSmith Product Trials and Downloads

From <>

System Center 2012 R2 Configuration Manager Toolkit

From <>

System Center 2012 Configuration Manager Support Center

From <>

Client Center for ConfigurationManager

From <>

Posted in ConfigMgr, MSI, Software Center | Leave a comment

New Intune features for Android

Interesting update:

New Intune standalone (cloud only) features that will be made available as part of this update include:

  • Management of Office mobile apps (Word, Excel, and PowerPoint) for Android tablets. (Management of Office Mobile app for Android phones made available in February 2015)
  • Ability to restrict access to Exchange on-premises for Exchange ActiveSync clients on Android devices
  • Ability to create WiFi profiles with pre-shared keys (PSK) for Android devices
  • Ability to resolve certificate chains on Android devices without the need to deploy each intermediate certificate individually
  • Deployment of .appx bundles to Windows Phone 8.1 devices (Support for .appx files made available in March 2015)
  • Managed Browser app for iOS devices that controls actions that users can perform, including allow/deny access to specific websites (Managed Browser app for Android devices made available in December 2014)
  • Management of Work Folders app for iOS devices
  • Updated Endpoint Protection agent for managing Windows PCs
  • Ability to manage Windows Defender on Windows 10 PCs running Windows 10 Technical Preview without need for separate Microsoft Intune Endpoint Protection agent to be installed
  • Combined Microsoft Intune Company Portal websites for PCs and mobile devices to provide a more consistent user experience across platforms
  • Added Windows and Windows Phone Company Portal apps to the Microsoft Download Center to provide an additional option for accessing these app downloads
  • Enhanced user interface for overview pages within Intune admin console


Posted in Android, Intune | Leave a comment

2015 IT Dev Connections Session


It is official! Garth Jones (@GarthMJ) and I (@Steve_TSQL) and I will be presenting:

 Advanced SSRS reports for ConfigMgr 2012 Admins

at IT/Dev Connections 2015 for more information and to register please visit,

Watch our blogs and twitter feeds for more details about this presentation!

Posted in 2015 Dev Connections, SSRS | Leave a comment

Migrating databases between SQL Server instances

If you ever have a need to migrate SQL Server databases between servers; particularly a backup/restore scenario, you need to be aware that the database security login ids are not automatically migrated. Here are some notes on this task.

Once databases are backed up from one instance and restored to another instance, database security needs to be transferred as well.

This task can be a challenge, fortunately Microsoft has created a SQL script that can be used for this purpose. This can be found here:

How to transfer logins and passwords between instances of SQL Server

The process is well documented. The steps are as follows:

1) From the transfer logins and passwords web page, copy/paste the SQL script to SQL Server Management Studio (SSMS) running on the SOURCE server.

2) Execute the script – it will create a new stored procedures on the Master database.

3) From SSMS, run the following query:

EXEC sp_help_revlogin

The output script that the sp_help_revlogin stored procedure generates is the login script. This login script creates the logins that have the original Security Identifier (SID) and the original password.

4) On server B, start SQL Server Management Studio, and then connect to the instance of SQL Server to which you moved the database.

Important Before you go to step 5, review the information in the "Remarks" section. (Note: see web page mentioned earlier)

5) Open a new Query Editor window on TARGET server, and then run the output script that is generated in step 3.

Posted in ConfigMgr, SQL, SQL Server, SQL Server 2012, SQL Server 2014 | Leave a comment

ConfigMgr – Why you need to implement DNS Scavenging

Interestingly, the topic of DNS scavenging came up on the MVP alias. Since it appears many client environments still have not yet enabled DNS scavenging, this article is dedicated to why you NEED to enable DNS scavenging. Before it is too late. (dramatic enough? ;)

First, a short story. While employed at a large financial services company as one of their Windows Engineers and lead SCCM architect, we started encountering some strange issues with SCCM remote control. Attempt to remote control a Windows client by NETBIOS name and *another* Windows client would be brought up in the remote control session.

After troubleshooting this issue, we came to the conclusion that there were multiple DNS records for the same NETBIOS name, each with a different IP address! So, it was rather random whether you’d actually remote control to the intended client. Turns out, in 5 years or so that Active Directory was in use, DNS scavenging had NOT been enabled, leading to 1,000’s of invalid, old entries. Implementing DNS Scavenging solved this issue.

What are some of the side effects of DNS with no scavenging? Here are just a few of the possible side effects:

– Remote control fails to reach the intended client

– Client Installation Push method fails to connect to the correct client

– OSD installations – software installations fail

– Client Inventory reporting

– Active Directory discovery issues

How to properly implement? There are a few things you need to know about DNS Scavenging; the first is implementing DNS Scavenging within DNS, then enabling at each DNS zone and the impact of DHCP lease duration.

Some general advice; I’ll usually enable and leave DNS scavenging set to the default 7 days per DNS zone. Since DHCP lease renewals happen approximately half way through the lease period, even a 7 day DHCP lease will typically be OK.

Scavenging should only remove those records that were dynamically registered, not the manually entered A records.

The recommendation would be to take a backup of your DNS environment prior to implementing. And, for the first implementation, starting on an evening or weekend is probably a good idea.

For those clients that get removed from DNS because they are on vacation for 2 weeks, they re-register when they re-connect, and will likely send a new ConfigMgr hw delta at the same time.


Script to locate duplicate DNS entries (thanks Russ):

Posted in ConfigMgr | 8 Comments

ConfigMgr 2012 R2 support for SQL Server 2014

ConfigMgr 2012 R2 does support SQL Server 2014, but only if it had been installed with SQL Server 2012, then upgraded to SQL Server 2014.

The interesting part arises, what if you have to perform a restore of ConfigMgr 2012 R2 on another server? If you install ConfigMgr 2012 R2, the recovery wizard will not work with SQL 2014. Then what?

Microsoft has addressed this issue with the following SQL 2014 restore hotfix (KB 3020755). Turns, out this hotfix is not CU dependent, and can be used to install ConfigMgr 2012 R2 natively with SQL Server 2014.

Posted in ConfigMgr, SQL Server 2014 | Leave a comment

SCU 2015 – Top 10 ConfigMgr 2012 Issues – SQL Content Links

Kent Agerlund and Johan Arwidmark; aka Robin and Batman (below) presented a great list of top 10 ConfigMgr 2012 Issues at the System Center Universe 2015 event in Irving, TX.


Appreciated the shout out to my blog for a few of the 10 ten issues; here are the direct links to save a little searching.

Top Issues

Slow or sluggish console performance… most likely culprit; out of date indexes and statistics

SQL Backups – take advantage of database compression

SQL PowerShell script – Kent touched on this one… how do you know if your database is fragmented, and a lot more.

Great event, thank you to the Catapult team and sponsors for making this event happen.

Posted in ConfigMgr, PowerShell | Leave a comment