While trying to install Spotlght on Messaging you will see the error below.
Error -2147217900: Failed to execute SQL string, error detail: CREATE DATABASE permission denied in database "master'., SQL Key: CreateDatabase SQL string: CREATE DATABASE [SpotlightManagementFramework] COLLATE SQL_Latin1_CP1_CI_AS
The Spotlight on Messaging service account is not a member of the dbcreator server role on the SQL server that the database is trying to be installed on.
Add the Spotlight on Messaging service account to the dbcreator server role on the SQL server that will host the SpotlightManagementFramework Database.
