Project Server, Project Server 2013

Project Server Queue Stuck “Waiting To Be Processed”

| | Leave a comment

After a fresh deployment of Project Server 2013 we hit a strange issue with jobs not being processed by the queue with the unhelpful status message “waiting to be processed”. After waiting for 15/20 minutes to see if the jobs cleared – which they didn’t – we then went through the following basic troubleshooting steps:

  • Restarted Project Queue Service and SharePoint Timer Service across the farm.
  • Checked the time was synchronised between the servers.
  • Cleared the queue and re-submitted some of the jobs.
  • Restarted the entire farm, including DB server.
Continue reading >>
SQL Server

Changing Physical Location of SQL Database Files

| | Leave a comment

Guide Notes

​This guide is written for SQL Server 2008 R2 and has not been tested on newer/older versions. While I believe the process is broadly the same, please make sure you check in a development environment before you follow this guide for other versions of SQL.

This guide will show you how to change the physical file locations for SQL databases (excluding system databases like master or model). This may be required if faster storage become available or you need to reconfigure your current SQL storage and need to move the files away from it temporarily.

This guide is not intended to be used to move SQL databases to a different server nor should it be used used to move SQL databases to a new instance. It is simply to change the location of back-end SQL database files without changing the SQL instance/SQL server. Continue reading >>

Office 365

Office 365 | Configure Permanent Passwords

| | Leave a comment

Office 365 doesn’t allow you to set passwords that do not expire through the GUI – the maximum you can configure here is 730 days. However, if you would like to set passwords to not expire, you can do so via PowerShell:

To set passwords for an individual 365 user to never expire:

Import-Module msonline

$cred = Get-Credential

Connect-MsolService -cred $cred

Get-MsolUser | Where { $_.PasswordNeverExpires –ne $true } | Format-Table DisplayName, PasswordNeverExpires, UserPrincipalName

[the above command shows all the user accounts with passwords set to expire]

Set-MsolUser –UserPrincipalName [UPN name, usually the main email address of the target user] –PasswordNeverExpires $true

Continue reading >>