DMARC described in one sentence

The sender's DNS stipulates that messages should contain a cryptographic proof of a valid sending server, when DMARC fails the messages did not contain this.

Remove 365 licenses from PC to resolve license issues

1.       Find the office install directory.  Should be here C:\Program Files (x86)\Microsoft Office\Office16.

-          There should be a VBS Script in the directory called ospp.vbs

      

2.       Sign out of Office – Make sure you sign out and remove anything office related in the Credential manager. Then close all office app including skype for business, Onedrive if running.

3.       Run CMD as Administrator and change to this directory C:\Program Files (x86)\Microsoft Office\Office16

The command below gets the product key or keys:

4.       Run the script – “cscript ospp.vbs /dstatus”

Run this command to remove the product key or keys if multiple keys is present. – Make sure to sign out of office first if not you will soon find out why.

5.       Remove the license - “cscript ospp.vbs /unpkey:8HRTP”

6.       Run this again “cscript ospp.vbs /dstatus” to double check the license is removed.

7.       Open word or excel and sign in with the account you want to license Office with.

Create user in Azure hosted SQL

Login to SQL Management Studio as the Azure defined SQL Admin

Change the items in red to those that you require.

In the Master Database
CREATE LOGIN username WITH password='password';

CREATE USER username FROM LOGIN username;

In the User Database.
CREATE USER username FROM LOGIN username;
EXEC sp_addrolemember N'db_owner', N'username'

For Read-only

CREATE USER username FROM LOGIN username;

EXEC sp_addrolemember N'db_datareader', N'username'