Zurück
-
Titel
[Error] System.Data.SqlClient.SqlException: CREATE FUNCTION permission denied in database 'tempdb -
Beschreibung
Unable to get the list of backup files of the SQL backups taken in the discovery phase of Recovery Manager for SharePoint (RMSP) in the RMSP console.
The following error is received in the "BackupDiscovery_S.log" file
"[Error] System.Data.SqlClient.SqlException: CREATE FUNCTION permission denied in database 'tempdb'."
-
Ursache
This issue is caused due to the RMSP service account not having the "CREATE FUNCTION" permission on the "tempdb" system database on the SQL server.
-
Lösung
Grant the RMSP service account permission explicit "CREATE FUNCTION" permission using the SQL Management Studio for the SQL server the "tempdb" database is pointing to. See screenshot.
-
Anhänge
