Friday, 23 March 2007

SharePoint Learning Kit requires specific permissions for the SLK Database or you get an error performing E-Learning Actions

Had an issue where having successfully installed the SharePoint Learning Kit (v1) and created the SLK database my Application Pool account for the Web Application where SLK was activated did not have access to the SLK database. The error appears when you try to use the SLK E-Learning Actions option on a resource.

SLK reports "An error occurred. More information may be available in the server event log." You may also see

"Cannot open database "SharePointLearningKit" requested by the login. The login failed. Login failed for user '".

This is resolved by assigning the Application Pool Account for the Web Application in question the following rights to the SLK database in SQL Management Studio: