SharePoint Training Server 2007
Greetings, I am trying to install the SharePoint Training Server 2007 on our test server, but am unable to see any content on the learner page. Both SQL and IIS are on the same box. The Application Pool account is also a local admin, and has the dbcreate, and securityadmin server roles. When I try to add the LearningStore role, I am unable to do so, as the user mapping for the service account shows up as dbo. Would I need to create a new account to manage the application pool, and then assign that account the LearningStore role? If so, what permissions should that service account have? Thanks for any help you can provide. Adam
June 14th, 2008 12:46am
Hello, I ran into the same problem: The warning note in the installation guide (page 12) is as follows: Note: If the application pool account is a db-owner, you will not be able to add roles to the database. In this case, you need to change the application pool account for the site collection to a non-db-owner account. I didnt want to change my application pool account. Instead I changed the owner of SharePoint TrainingKit database. I ran the sp_changedowner stored procedure to change the owner of SharePointTrainingKit database to another account. See SQL script below. Then went back to Management Studio Login, then user mapping, and added LearnStore role to SharePointTrainingKit datatabase. That worked. Here's the script: Go in to SQL Server Management Studio and execute the following stored procedure: --use [currentdatabase]--go--sp_changedbowner 'yourusername', 'true'--go USE SharePointTrainingKit GO sp_changedbowner 'your user name', 'true' Go This will change the owner of the current database to whatever username you want ( you could put sa in there ) and then remap any alias as well (that's the true). Hope that helps. Tom
June 24th, 2008 11:34pm
Worked perfectly, Thanks.
June 11th, 2010 8:12pm