Archive for the ‘Information’ Category

Creating, or recreating, a SQL user account and I forgot to untick the “must change password” option. Damn.

If you try to disable the password policy options, you get a message saying “The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON. (Microsoft SQL Server, Error: 15128)”

Rather than recreate the account, you can disable the options using a script

Source: http://www.webofwood.com/2009/01/29/fix-a-sql-server-login-which-has-must_change-set-to-on/

USE Master
GO
ALTER LOGIN [username] WITH PASSWORD = 'samepassword'
GO
ALTER LOGIN [username] WITH
      CHECK_POLICY = OFF,
      CHECK_EXPIRATION = OFF;

 

 

When trying to open a OneDrive folder on the computer you get a catastrophic failure message. This is related to the “Offline” attribute for that folder being reset, possibly due to some other program or action that had been performed in the past.

onedrivecatastrophicfailure

The same folder can be opened from Windows Explorer when selecting the folder from the left pane view, but the message appears when opening the folder from the right pane view.

You can check the folder location by right-clicking and selecting “Properties”onedrivepicturesproperties

Open a CMD prompt, CD to the OneDrive folder location found in the properties and use the ATTRIB command to reset the Offline attribute for the folder

ATTRIB -O "Pictures" /s /d

 

onedriveattribreset

If there are a lot of folders showing this issue, the same command can be run against the whole OneDrive folder instead

ATTRIB -O /s /d

A quick reference for the error codes when you get Activation error in Windows

http://windows.microsoft.com/en-us/windows-10/activation-errors-windows-10

 

Each new update of ConfigMgr I will start a new entry for anything specific to that version I want to test or make notes of.

(more…)

Often if editing something like a Boot Image or Task Sequence and you experience a console crash, then next time you try to edit that object you may see a message saying it is currently locked for editing, giving only a choice to wait or open as Read-Only.

Some quick (unsupported) database edits can clear the lock, or there is a Powershell command that does the trick as well. The Powershell is a bit trickier, but is the “proper” supported method.

https://configmonkey.wordpress.com/2015/03/27/powershell-how-to-unlock-objects-in-sccm/

Powershell Unlock-CMObject: https://technet.microsoft.com/en-us/library/jj821915(v=sc.20).aspx

and more info on how SEDO works: http://blogs.technet.com/b/sudheesn/archive/2012/10/28/sedo-serialized-editing-of-distributed-objects-configmgr-2012.aspx

 

 

As part of the Insider program I get rather frequent upgrades to Windows 10. Each time the upgrade installs it resets my speech language to “English (United States)” which means Cortana stops working as my Region is set to “Australia”

I also use ConfigMgr to handle updates on my network (this would also apply for people using WSUS) so when I go into the Region & language settings I don’t get the Speech feature appearing under the “English (Australia)” options.

Luckily, it is relatively easy to sort out.

SOLUTION:

(more…)

I am starting work on now upgrading have upgraded our ConfigMgr2012 R2 hierarchies to the new “Configuration Manager with no more version numbers” build 1511. There are roughly 120+ site servers in the central hierarchy (across 2 CAS hierarchies), so hopefully things go well. For the most part things went quite well, no major issues at all.

I’ll keep this page to note any special gotchas that are outside the various step-by-step guides already out there, and also some easy quick link references.

(more…)

This will be a quick reference page for links to build numbers for versions of various products

Configuration Manager 2012

Exchange 2007-2010

Exchange 2013

SQL Server

Windows Server and Workstation – Need better reference with build numbers

During the process of numerous upgrades of the OS during the Windows 10 technical preview, I’ve found quite often that my Windows Apps often stop working properly, or display as non functioning icons showing the meaningless name of the app instead of the proper app tile.

Two quick things to try to resolve:

  1. From an elevated command prompt run “wsreset”
    1. This will trigger a “Windows Store Reset” and may or may not resolve any initial problem you have opening the Store App
  2. From an elevated Powershell prompt, run the following
Get-AppXPackage | Foreach {Add-AppxPackage -DisableDevelopmentMode -Register "$($_.InstallLocation)\AppXManifest.xml"}

This should re-register all the apps that appear in your app cache.

There are still many other potential issues you might encounter such as proxy servers blocking access or corrupt apps, but it’s a relatively easy starting point.

This has happened to me a couple of times in the various Technical Preview updates where the start menu stop working.

It turns out a simple powershell command will rebuild the appcache to resolve

Run this in Powershell as admin

Get-appxpackage -all *shellexperience* -packagetype bundle |% {add-appxpackage -register -disabledevelopmentmode ($_.installlocation + “\appxmetadata\appxbundlemanifest.xml”)}