SQL Server - contains an invalid XML identifier as required by FOR XML;

You can't have spaces in XML element or attribute names. Use

SELECT Username AS [LastName],
       ''       AS [MiddleName],
       ''       AS Birthdate,
       ''       AS [SSN],
       0        AS [WageAmount]
FROM   Employee
FOR XML PATH