Regresar
-
Título
Error -2147217900: Failed to execute SQL string, error detail: -
Descripción
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
-
Causa
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.
-
Resolución
Add the Spotlight on Messaging service account to the dbcreator server role on the SQL server that will host the SpotlightManagementFramework Database.