SharePoint Learning Kit: Installing on Single Server Farm
[LEFT][CODE]http://ajp-blog.spaces.live.com/blog/cns!9F9715547E4A30BE!212.entry[/CODE]
I've seen a few requests recently for the SLK install documents to be updated to show how to install SharePoint Learning Kit onto a single server environment. This is something that I encounter a lot with my installs so thought it was time to do a post about it.
When you install MOSS or WSS3 onto a single server the install wizard automatically installs SQL 2005 on the same box but when you go to create your SLK database you get the below error message!
[COLOR=#ff0000]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)[/COLOR]
[COLOR=#ff0000]
More information has been written to the server event log.[/COLOR]
[U]Install SLK onto a Single Server[/U]
Having installed MOSS or WSS on your single server download SharePoint Learning Kit from [URL="http://www.codeplex.com/slk"]www.codeplex.com/slk[/URL]
Extract the SLK zip file in a new folder.
Run [I]AddSolution.cmd[/I] - This will add SharePoint Learning Kit to your farm
[URL="http://a9bkxg.bay.livefilestore.com/y1pIVtE53xraVcZHEu3lGYVJ2n8ohLcBp2x2l-a9vEHJvXIh3j8XM1gEHtZzHYMTFqEMvfo_BuHkdoS4Q_UOcGWvw?PARTNER=WRITER"][IMG]http://a9bkxg.bay.livefilestore.com/y1pTTAxqAxkuDxBq9uZ4f4FHAhI1_DpWBON-NlyzQY9L4GF3iSBesRnu-Ky7LMIowm5mN2VO56o51nDUphyNxM_HSkNs7N4dI4K?PARTNER=WRITER[/IMG][/URL]
To add it to your default site you need to run [I]DeplySolution.cmd[/I]
[URL="http://a9bkxg.bay.livefilestore.com/y1pTTAxqAxkuDyY1wYUKbWOuUGaec5ilHuN7cLZpgvx8gR9ze9FZ4kIuz2V0jMAGk5ejERAHIqKJcQHXCPoZZDPPz0G-nxUx5-B?PARTNER=WRITER"][IMG]http://a9bkxg.bay.livefilestore.com/y1pIVtE53xraVfW_nG7DdqGZ8GGkpQ0qBkq5vrDGS1ngnEqXkyywzU3_Rw8wKFBSYjlP_6Rq4XkJd3x56AlO2K-3w?PARTNER=WRITER[/IMG][/URL]
This has now deployed the [I]MyAssignment WebPart[/I] to your default site and add the [I]SharePoint Learning Kit Feature[/I] but now you need to create the SLK database.
Open [I]Central Administrator[/I] and go to the [I]Operations[/I] tab
Under [I]Data Configuration[/I] click on [I]Default Database Server[/I]
[URL="http://by1.storage.msn.com/y1p6oUdNMdXCa21rbna0xdxVUxXh_R5TWtu-FxxZL9Zqaw8JZTeXTlrBm6J1R414Lf8SQyre5VwYtTIz6UlMsjk2qZ026I3r1NN?PARTNER=WRITER"][IMG]http://by1.storage.msn.com/y1p6oUdNMdXCa2qu-XPdtUNw-5H2N1R9LctPpO6uxE5yzWWYiyYBQkP1NVGzJoPe_Qm8KrZpjwMHKo8JwLDgnEye8BqQzVlDAxJ?PARTNER=WRITER[/IMG][/URL]
You will see[I] Default Database[/I]. This is normal called {yourserver name} followed by OfficeServer. [I]Copy[/I] this information and click cancel
[URL="http://a9bkxg.bay.livefilestore.com/y1pTTAxqAxkuDx83Q-s7c3NLU3o-rp5d8yWw3mGZn94jZc1Syy6R0fUmlVxub4s3TBqaGW03WELOhYfR_1l743bl-x5phJBlzJS?PARTNER=WRITER"][IMG]http://a9bkxg.bay.livefilestore.com/y1pTTAxqAxkuDwE1mVLrWtHugWZ7MObt9FV5f2RNi3quaumqniQJ1Mt1oBDvaDguLG5CH7xh03k5xDBv7tWOqk-6JcN09aEwZzL?PARTNER=WRITER[/IMG][/URL]
Now click on [I]Application Management[/I] at the top
At the bottom you will now see a new area called[I] SharePoint Learning Kit Configuration[/I]. Under that area click on [I]Configure SharePoint Learning Kit.[/I]
In the [I]Database Server[/I] box, paste the same information you copied from the default database.
[URL="http://by1.storage.msn.com/y1p6oUdNMdXCa2BiPI35iwHzUMletqOilmNRee5j1tminqzyAP-X1u0HGA5yWMy66xEwDUYg-HwaYgJsKMobzWWe3NFAOLSnm14?PARTNER=WRITER"][IMG]http://a9bkxg.bay.livefilestore.com/y1pTTAxqAxkuDxlg4lto-2a-ZN6cxZkssQZEGMKNfpCOwxFF-CFAUSdOTHGfGIvdT257xFK8zWO8QNhHmQBm7cRw9e049MT-fpE?PARTNER=WRITER[/IMG][/URL]
Now when you click ok you will be able to create the SLK database needed for SLK to work.
A quick tip - if you open [I]Configure SharePoint Learning Kit[/I] with [I]Create New Database[/I] unchecked - it has connected and created your database for you
[/LEFT]