Archive for January, 2017

MSSQL user can’t connect until password change

Posted: January 14, 2017 in Information, SQL
Tags:
0

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;

 

 

OneDrive Catastrophic Failure

Posted: January 2, 2017 in Information, Solved, Windows 10, Windows General
Tags: , , ,
2

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