So you want to install Sharepoint V3.0 onto SBS 2003?

Let me show you the ways.

Well more accurately let the article I just created tell you. You can find it here in the Supportweb Document Library as free download. The article takes a brief look at the different options and considerations you need to make before installing Sharepoint V3.0 onto a Small Business Server 2003.

If you don’t already know then you shouldn’t do an in-place upgrade (it breaks things if you do), you also have the option to install the Sharepoint into SQL if you want (although the “official” Microsoft procedure doesn’t mention that).

The articles looks at the installation of Sharepoint V3.0 on SBS from a reseller or systems implementer’s perspective, however hopefully this doesn’t mean that it won’t have value for other attempting this kind of installation. I also mention some of the benefits the Microsoft Search Server 2008 will bring to SMB space given its ability to not only index Sharepoint content but also file shares.

As always I appreciate any feedback on this article or any of the material that I create. Also, if you are interested in something specific them also let me know since I like to create material that is of benefit to “real” people.

Sharepoint Document libraries – Part 3

You’ll find our latest video on Sharepoint Document libraries now here on YouTube. It shows you what is under the covers of the settings menu option in document libraries. This menu allows you to do things like changes the title and description of the library, manage the permission and RSS settings and configuration. The settings menu also allows you to configure columns and views.

For the time being, this will conclude our look at Sharepoint document libraries.

Can I just say these people still don’t understand e-commerce

Well it is coming up to Christmas time and the “easiest” way to go shopping is the via the net right? Let me just show you how even big suppliers don’t understand e-commerce.

Firstly, I wanted to buy some DVD’s and CD’s from a major retail chain. I login with my credentials so it knows who I am and records my purchases. Nowhere can I see how many “bonus points” I have with this supplier on the page, which would be nice. So I select what I’m after, add it to my shopping cart and then head to the checkout. After putting my credit card details in I’m now taken to “Verified by Visa”. Here I have to put in a “Verified by Visa” password that I have no idea what it is. Sure I set it up but this is the only site that I’ve seen that uses “Verified by Visa”. Not having my password means that I am unable to complete my purchase. So I request my password (which terminates the checkout process anyway). I have to wait a few minutes and check my email for the details, then I go back in and re-order everything, put in my ‘Verified by Visa’ password and complete the transaction (and only get shown my bonus credits at checkout). When I receive a confirmation of my purchase on the web site I also receive an unknown pop-up that gets blocked by my browser. Hmmm… I wonder what the pop up says and if it is important? I take a screen shot of my completed transaction details because I know what is about to happen next. I enable pop ups in the browser so I can see what the message and is and surprise, surprise my completed transaction details have disappeared from the original browser window because the window was reset when I enabled the pop up.

Issues :

1. Why, oh why do I have to jump so many hurdles to give you people my money? Why, oh why can’t I check my ‘Verified by Visa’ password BEFORE I have to enter it? Why, oh why can’t I elect to not use ‘Verified by Visa’ if I so desire? Sure there is security risk but I just want to pay my money and get out. Dumb.

2. Why is the site using pop ups? Geeze fellas these things went out with Internet Explorer 4.0. The only things that use pop ups these days are annoying ads and spyware. Every browser these days blocks pop ups by default so everyone is going to have the same problem of losing their transaction info if they view the pop up. Was there are warning prior to processing that I should enable pop ups? No. Dumber.

Next, I went to purchase some books. I locate the first book I want and add it to my basket which conveniently displays. Ok boys, now how the hell do I get back and make more purchases? I scout around the page and see no indication of a return link. So where’s the encouragement for me to buy more? Finally I find that if I click on the company’s logo in the top left of the screen I go back to the main site. Hmmm…my basket now shows that it has 0 items. I click back on my basket and find that it does in fact still have my initial item. I again return to the main page and make more purchases. When complete I proceed to the checkout where I am asked for my loyalty card number. Yes, I do have one of those. I enter the number and it says “invalid number or password”. Hmmmm…. ok I’ll request my password (again) and guess what it was correct! So what’s the problem here? After much stuffing around I work out that the number I need to enter must not include any dashes (‘-‘), I must just type the number in straight. Where the hell did it tell me that? Bloody hell I just wasted 5 minutes trying to working out what I was doing wrong when all you needed to do was tell me that I should only use the numbers on my loyalty card. Mr(s) supplier, you have either just wasted my valuable time and gotten pissed me off or I have wasted time I could have spent shopping for more product on your site.

Issues:

1. Navigation. Has anyone else except the snow boarding web designers and poor suffering customers ever looked at the shopping basket page? Clearly not, since it must be so bloody obvious to press the logo in the top left of the screen to return to the main page to purchase more (Yeah right).

2. If you give me a card with a number separated by dashes I am going to assume that when I’m asked for that number you want it exactly how it is printed (ie with the dashes). If not, then pay me the courtesy of telling me this rather than wasting my time and pissing me right off. Dumbest.

In the end, sure I made my purchases and sure maybe I should be more forgiving but take a look at the check process differences between US and Australian sites. The big US sites really make it easy and want me back, these Australian sites just piss me off so I would rather go into the store. C’mon guys get the fundamentals right. Set you sites up to make it EASY for the customer to buy, stop putting all these barriers up. You complain about the lack on online sales but have you EVER looked at the check out process through the eyes of real consumer? I doubt it, I doubt it and that is plain stupid.

Blocked file types in SharePoint

Any files trying to be uploaded into Sharepoint V3.0 with the following file extensions will be blocked by default :

ade
adp
app
asa
ashx
asmx
asp
bas
bat
cdx
cer
chm
class
cmd
com
config
cpl
crt
csh
der
dll
exe
fxp
hlp
hta
htr
htw
ida
idc
idq
ins
isp
its
jse
ksh
lnk
mad
maf
mag
mam
maq
mar
mas
mat
mau
mav
maw
mda
mdb
mde
mdt
mdw
mdz
msc
msh
msh1
msh1xml
msh2
msh2xml
mshxml
msi
msp
mst
ops
pcd
pif
prf
prg
printer
pst
reg
rem
scf
scr
sct
shb
shs
shtm
shtml
soap
stm
url
vb
vbe
vbs
ws
wsc
wsf
wsh

This list will apply not only to the uploading of documents, but also to extensions changes of documents once they are in a document library. So if you have .zip file in a document library and try to unzip that file into a document library and the .zip contains a .exe file then that document won’t extract.

To configure blocked file types:

  1. Go to Sharepoint 3.0 Central Administration.
  2. Select Operations page.
  3. Select Blocked File Types under Security Configuration.
  4. Modify the list to include or exclude the file extensions required.
  5. Click OK to save and close.

SharePoint V3.0 file locations

When you install SharePoint V3.0 onto SBS 2003 using the standard “side-by-side” installation you will find the following locations in use :

:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Data\Applications\\Config – contains global configuration files used by the search engine, like language specific noise word and thesaurus files along with the thesaurus schema XML file.

C:\Program Files\Common Files\Microsoft Shared\SERVER12\Server Setup Controller – critical setup files that might be needed later fro re-running certain aspects of the setup and configuration wizard.

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN – executables like stsadm and prescan.exe

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS – administrative pages address by the _layouts relative path on the Sharepoint sites.

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\IMAGES – is the _images realtive path for images addressable anywhere in Sharepoint sites.

SharePoint V3.0 databases

When you install Sharepoint V3.0 onto SBS 2003 using the recommended installation from Microsoft you will end up installing the WMSDE database that was mentioned in a previous post. This is typically referred to as the \Microsoft##SSEE SQL instance. Now of course you could manipulate this from the command line using the osql commands but if there is GUI interface why no use that? If you download the Microsoft SQL Management Studio and install that you can use a GUI to interact with the WMSDE Sharepoint databases.
So what do these databases do ? Well :

  • Sharepoint_AdminContent_ stores the information related to lists, document libraries, tasks and so so on of the Central Administration site.
  • Sharepoint_Config_ stores information about the configuration of your Sharepoint farm. Things like servers and their role are saved here. If the farm involves a multi server environment (with web front ends, content and search servers) then how the whole farm is configured is held here. BY default each server in the farm checks with the configuration database every 30 seconds.
  • WSS_Content contains information related to lists, document libraries, tasks, wikis, blogs, structure details, security information and so on for your Sharepoint user site.
  • WSS_Search_ contains search metadata, history log, search log and so on that is used for the inbuilt Sharepoint search functionality.

Remember there is only a limited amount of things you can do with the SSEE instance but the GUI certainly makes it easier and now at least you have some idea as to what each database does!

SharePoint V3 databases

When you install SharePoint V3 on SBS2003 in the manner recommended by Microsoft (side by side installation), SharePoint will install Microsoft SQL Server 2000 Desktop Engine (Windows) known as WMSDE.

WMSDE
The MSDE version that ships with Windows SharePoint Services is called as Microsoft SQL Server 2000 Desktop Engine (Windows)-(WMSDE). WMSDE and has no storage limits unlike MSDE.

When you install Microsoft Windows SharePoint Services on a single server using the defaults, you have an installation that uses Microsoft SQL Server 2000 Desktop Engine (Windows) (WMSDE) for your databases.

Some of the WMSDE Limitations as follows.
1) Cannot use WMSDE for web farm setup.
2) WMSDE overcomes limitations that MSDE has (like 2GB size limit, number of simultaneous connections). However you can’t use it for anything else, because you can only use it for a specified signed schema (WSS Schema).
3) No Full Text search.
4) The instance of WMSDE installed can be used only by WSS.

Also, no matter where you specify the installation of Sharepoint you’ll find that WMSDE installs under the Windows directory, which typically is on the C: drive of your server. Now this drive may not have enough space if you are planning a large Sharepoint environment so beware as WMSDE, from what we can determine, has no database limits. This means that the Sharepoint database could in theory grow and fill the entire C: drive.

If you are looking for the location of the Sharepoint V3 content databases that have been installed with WMSDE you’ll find them at :

c:\windows\sysmsi\ssee\mssql.2005\mssql\data

This will be the case if you have SBS 2003 standard or premium and simply accept the default installation options for Sharepoint V3. If you have SBS 2003 Premium, that includes some version of SQL, then you are able to have the Sharepoint content databases reside on the SQL server, which typically will be on the data drive of your server and not the system drive. However, to achieve this configuration you need to do thing differently from the way Microsoft recommends.

More on that later.