SLK 1.0.799 Database Creation Error

Topics: Developer Forum
Jan 17, 2007 at 4:43 PM
Hi all,

Just a quick question, hopefully you can provide an easy answer. I have installed the 1.0.799 version of SLK, with WSS 3.0 and SQL Server 2005 Express (using the Getting Started instructions, just for a proof of concept test), but I have run into the following error when trying to configure the SLK:

CREATE DATABASE permission denied in database 'master'.
More information has been written into the server event log.

And from the server error log:

SharePoint Learning Kit Error

System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in database 'master'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SharePointLearningKit.SlkAdministration.CreateDatabase(String databaseServerConnectionString, String databaseName, String databaseConnectionString, String appPoolAccountName, Byte[] appPoolSid, String databaseSchema)
at Microsoft.SharePointLearningKit.SlkAdministration.<>cDisplayClassb.<SaveConfiguration>b4()
at Microsoft.SharePointLearningKit.SlkUtilities.ImpersonateAppPool(VoidDelegate del)
at Microsoft.SharePointLearningKit.SlkAdministration.SaveConfiguration(Guid spSiteGuid, String databaseServer, String databaseName, String schemaToCreateDatabase, String instructorPermission, String learnerPermission, Boolean createPermissions, String settingsFileContents, String defaultSettingsFileContents, String appPoolAccountName, ImpersonationBehavior createDatabaseImpersonationBehavior)
at Microsoft.SharePointLearningKit.AdminPages.ConfigurePage.BtnOk_Click(Object sender, EventArgs e)

I just need to know how to add the permission so that SLK can create the database. Any help would be greatly appreciated.

Cheers,
Shawn