VERIFIED SOLUTION i

What are the requirements for the Content Author SQL User ID and Password?

Product Feature: Installation
Operating System: Windows
Database: SQL
 
The Content Author database SQL user (Default: MSG1User) requires dbcreator, processadmin, and db_backupoperator role.

The password policy is managed by the Microsoft software. Please click on the following Microsoft link for an explanation.
https://msdn.microsoft.com/en-us/library/ms161959.aspx
 
UPDATED:  April 28, 2017