Tag Archive: SharePoint

Why would you do this?

Users of your website want a friendly name (such as intranet) rather than UKWebSrv01

1.       Go to Start -> Administrator Tools -> Internet Information Services Manager

2.       Expand Web Sites and right click the Web site you want to add the host header to.

3.       Select Properties of the Web site

4.       On the Website tab, click Advanced

5.       In the multiple Identities for this Website section, click Add and complete the following fields:

a.       IP Address                                        Leave as All Assigned

b.      TCP port                                             Type 80

c.       Host Header Value                        Type the name that users will type when accessing the website (e.g. Intranet.mydomain.com)

d.      Click Ok, then click Ok again, and click Ok again to leave the Properties Page

All that remains now is for the domain administrator for DNS to add the new host header name to DNS for the mydomain.com domain and the correct IP Address for the Web server.  Once the DNS entry has replicated, any requests for that URL will be redirected by IIS to the correct website.

I found this link, which is really useful:


Repeated here for ease of searching

Recently I was fixing on one server an installation of Windows SharePoint Services that has gone wrong. Even though we’ve had SQL server 2005 installed correctly, WSS3 installed its own Windows internal database (##SSEE) and started using it. I thouhght a simple uninstall and reinstall of WSS would do the trick. But it didn’t. After uninstalling and trying to reinstall WSS3 at the beginning didn’t even offer the option to configure it to SQL server (the step in WSS configuration where is asking you which is the location of configuration database,…).

After a couple of retries (also uninstalling SSEE and a lot of reading on the web to my horror I’ve found one sentence "you’ll need a clean install of Windows Server 2003."


This was a bit tough because of existing users and some other parameters. After digging a bit deeper and combining knowlege of couple of experts’ blogs I’ve managed to successfully reinstall WSS3 without Windows Internal Database (SSEE) and into SQL server 2005.

Before I write how I did it, let me clear that this solution worked for me. I’m presuming that you don’t have anything else installed in SSEE and I’m not responsible for any errors that might happen if you’re following the same procedure. So please before making anything on a production server – backup, backup, backup. This procedure includes messing with Windows registry!

Here goes:

1. Copy all the SharePoint Sites to another temporary folder

stsadm -o backup -url http://<site_collection_url&gt; -filename <location and filename>

copying backup files to new server and

stsadm -o restore -url http://<site_collection_url&gt; -filename <location and filename>

on the temporary server worked the best. It kept all the relations and all the custom formatting on all the sites.

2. If these are productions sites modify DNS or forwarding to point to the temporary server

3. Here’s where the "fun" begins: Delete all the SharePoint Web applications

4. Uninstall Windows SharePoint Services through Control Panel

5. Uninstall Windows internal database (##SSEE)
Connex’ Copper Coins has it described in his blog here. Just in case I’m writing a short ressume:

Under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall click different GUIDs untill in the right pane you see under "Display name" Microsoft SQL 2005 Embedded Edition". Under that registry copy the value under "UninstallString". Run the command prompt window, paste the command AND add "CALLERID=OCSETUP" at the end of commend line. For example: MsiExec.exe /X{BDD79957-5801-4A2D-B09E-852E7FA64D01} CALLERID=OCSETUP.EXE.

(ressumed from Connex’ Copper Coins)

6- Delete all files and folders under %windir%\SYSMSI\SSEE

7. delete all and folders files under %Programfiles%\Common Files\Microsoft Shared\web server extensions\12

8. Using reged backup and delete in registry everything under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\

9. The previous step also deleted the "Server language" entry. so Using notepad create a .reg file with the following text:

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\ServerLanguage]

and run it to restore the "Server Language" entry needed for Windows SharePoint Services installation.

With that I have removed every trace (or at least enough) of Windows SharePoint Services 3.0 from the server. Now I was able to re-run the WSS 3 setup and and it offered me the option for nstalling it into SQL server 2005 and without SSEE.

This is how you can have it done without making a clean install of Windows Server 2003.

I took the Configuring Microsoft Office SharePoint Server 2007 exam yesterday and passed.


It was a comparatively straightforward one, and the experience of working with SharePoint over the past year has greatly helped.

To prepare for the exam, I took the Microsoft eLearning course (5404) which was very useful.

Recently, I had need to create a feedback form in SharePoint Server 2007. Having looked around the internet for information on the best way to do this, which varied from creating an external website (!) to a number of custom written webparts, I found a good solution; and its a great feature (I think!).

Creating a Feedback form in SharePoint Designer

1. Create a Custom List in SharePoint, and specify the columns you want (these will be the fields on the feedback form).


2. Create an empty page for the Feedback form to go on

3. Create an empty page for the Thank you page to go on.

4. Fire up SharePoint Designer, and open your Feedback form.

5. Add your Feedback list to the form. This is done by opening the data source library, and the SharePoint lists section.


6. Choose the List you created earlier, and click Show Data.

7. Select the fields you want from the list


8. Click on the ‘Insert Selected Fields as…’ box and choose ‘New Item Form’. Your fields will then be added to the page, along with a Save and Cancel box.

9. If you then right click on the Save button (I’d be inclined to rename it to Submit, but thats up to you), you can choose Form Actions.


10. You can then set the actions that take place when you click the Submit button. If you add a Navigate to Page action, you can specify where to take the user when they’ve entered their information.


11. There you go. All done. You have your Feedback page, where visitors can enter information, and a list. Once the visitor has entered the information, it will appear on the list you created.

How straight forward is that ? and no coding whatsoever.


We had a number of requirements for a Coloured calendar, and I found a great solution to this. You can see it here: