Using SLK with SQL server 2008

Mar 29, 2009 at 12:49 AM
I would like to add the SLK database to my SQL server 2008 farm but I am having issues logging into it from SLK with slkadm.exe.  Is SQL server supported or is only the express version supported?
Coordinator
Mar 29, 2009 at 11:57 PM
Full and express are supported. What command are you running and what error are you getting?

Richard
SLK Co-ordinator
http://blog.salamandersoft.co.uk
Mar 30, 2009 at 12:25 AM

slkadm.exe -o configuresite -url http://intranet/training/ -databaseserver "SEERVERNAME;user id=username;password=mypass" -databasename SharePointLearningKit

Configuring SLK for site: http://intranet (34066531-e817-4b03-aaab-f8e32cf7319f)
Error: System.Data.SqlClient.SqlException: Invalid object name 'Configuration'.
   at System.Data.SqlClient.SqlConnection.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.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOption sString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.LearningComponents.Storage.LogableSqlCommand.Execute(String commandText)
   at Microsoft.LearningComponents.Storage.LearningStore.GetSchemaInformationFromCache(String connectionString, ImpersonationBehavior impersonationBehavior, TextWriter debugLog)
   at Microsoft.LearningComponents.Storage.LearningStore.GetSchema()
   at Microsoft.LearningComponents.Storage.LearningStore.CreateJob()
   at Microsoft.SharePointLearningKit.SlkAdministration.SaveConfiguration(Guid spSiteGuid, String databaseServer, String databaseName, String schemaToCreateDatabase, String instructorPermission, String learnerPermission, String observerPermission, Boolean createPermissions, String settingsFileContents, String defaultSettingsFileContents, String appPoolAccountName, ImpersonationBehavior createDatabaseImpersonationBehavior)
   at Program.ConfigureSite(IEnumerator argEnum)
   at Program..ctor(String[] args, Boolean& pause)
   at Program.Main(String[] args)

 

Mar 30, 2009 at 2:21 AM
My database farm does not allow my to create databases as I have to contact my IT department to do so, but other than that I should have full permissions
Apr 1, 2009 at 5:23 AM
I have submitted this as a bug http://slk.codeplex.com/WorkItem/View.aspx?WorkItemId=21869
Coordinator
Apr 2, 2009 at 4:32 PM
The command you are runnings says that you want to use the already existing database SharePointLearningKit to store the SLK information for http://intranet/training. What you need to run to create a new database as well is

slkadm.exe -o configuresite -url http://intranet/training/ -databaseserver "SEERVERNAME;user id=username;password=mypass" -databasename SharePointLearningKit -createdatabase

You'll need to get your IT department to do it if you haven't got create database permissions.

Richard