Is "SET IDENTITY_INSERT" required to insert arbitrary GUID into [uniqueidentifier] column?
IDENTITY_INSERT is only used for columns with the IDENTITY property.

UNIQUEIDENTIFIER is merely a data type.

Your insert statement will work.