VSTO & .NET & Excel

February 14, 2009

SharePoint – The Start

Filed under: SharePoint, SQL Server — Dennis M Wallentin @ 2:01 pm

Last year I decided to learn more about Microsoft Office SharePoint Server (MOSS) and in particular Excel Services. Instead of setting up a VMWare configuration I decided to buy a physical server to which my developing machine will be connected to as the only client.  Because of my security approach none of these two machines have access to Internet. Yes, I’m the first to admit that I’m paranoid but that is the way it is.

I got a nice price for the server Fujitsu Siemens FSC PRIMERGY ECONEL 100 S2 and bought more memory so it now has 2 GB. The server has two hard drives and therefore I decided to use a RAID 0  solution so one drive mirror the other drive. Previously I only had a 2 port KVM Switch but now I needed a 4 port Switch so I can switch between my laptop, my development machine and the server. The model I selected was Athen CS1734B which is one of a very few KVM Switches that can work with Windows Server 2008.

I decided to use Windows Server 2008 x64 standard edition which also gives access to the Hyper V technology. Unless we have all the knowledge required to configure and running a server and installing all the softwares we need some helps. In my case I prefer printed books and the help I got is from the book “Windows Server 2008 A Beginner’s Guide“. It covers the most basic to install and configure a Windows 2008 server and is written in a understandable way.

Next, a SQL Server 2008 Express Edition was installed and it did not cause any problems at all.

Installing a MOSS 2007 server requires one important preparation, to set up 11 accounts with names and passwords. They are required for both the Windows SharePoint Services (WSS) and for the MOSS server. Andreas Glaser has published a nice installation guide; Installing MOSS 2007 on Windows Server 2008 and SQL Server 2008 . However, to understand more a book is required and I was recommended to use “Beginning SharePoint 2007 Administration” written by my fellow countryman Göras Husman. At present I have only started to read the book.

Finally, the only thing that remains to do is to learn more about MOSS and what we can do with its Excel Services!

Kind regards,


  1. Hi Dennis,
    Well so starts the journey, i look forward to reading about your progress!
    Good luck with this new project and as always thanks very much for sharing you considerable knowledge!


    Comment by ross — February 14, 2009 @ 5:10 pm

    • Ross,

      Thanks and I’m very curious where this project will take me.

      Kind regards,

      Comment by Dennis Wallentin — February 14, 2009 @ 6:06 pm

  2. “Thanks and I’m very curious where this project will take me.”

    Many years ago (95) we have Excel 95 (workgroup)running on a Norton Server

    We had one copy of Excel and many users could open it on their “terminals” and save files on their network directory

    Years later we have Sharepoint + Excel Services

    Comment by sam — February 16, 2009 @ 9:04 am

  3. Hi Dennis

    Congratulations with your new machine. Using it for development you should be aware of a lot of tweaks needed to make your 32bit code run in the 64bit asp.net version MOSS uses.

    If you can afford it I’ll recommend you to add more memory to your machine – going from 2GB to 4GB+ is really something.

    Take a look at STSDEV (www.codeplex.com/stsdev) to easy development for MOSS

    Comment by Henrik Sørensen, DK — February 16, 2009 @ 9:08 am

  4. Henrik,

    Thanks for all the information 🙂

    I was not aware of that it will require some tweakings between 32bit and 64bit code.

    As for the suggestion to get more memory it confirms what I have suspected. I have decided to upgrade it to 4 GB.

    Kind regards,

    Comment by Dennis Wallentin — February 16, 2009 @ 12:21 pm

  5. sam,

    What you say confirms in a way that we tend to go in circles rather then moving forward.

    Kind regards,

    Comment by Dennis Wallentin — February 16, 2009 @ 12:22 pm

  6. Hi Dennis

    Main problem is that you would normally only be allowed to run 1 version og ASP.NET in an application pool, and because MOSS runs in 64 bit … applications running within MOSS also runs default in 64 bit … but a lot of 3.party programs expect 32 bit … and therefore you will have to google for the tweeks mixing them together in the same app.pool.

    MOSS is by all means the most crappy platform-thing Microsoft has ever released but they are using it out there so bette be there too.

    Take special care about the total lack of tools to move a MOSS application from development to staging and further to production… M$ has a LOT to learn in this field.



    Comment by Henrik Sørensen, DK — February 16, 2009 @ 12:46 pm

  7. Henrik,

    # 32bit vs 64bit
    What You’re saying is that the best route to take is to use the 32bit version of Windows Server 2008.

    # MOSS
    Interesting to learn, especially as it is said that MOSS is the fastest growing server in my corner of the world.

    Once again, thanks for Your valuable input.

    Comment by Dennis Wallentin — February 16, 2009 @ 12:54 pm

  8. Hi Dennis

    No – You should absolutely deploy Win2008 in 64 bit and MOSS in 64 bit as well. No doubt about that. Most customers will run MOSS in 64bit in the near future.

    MOSS runs faster and more reliable in 64 bit mainly because of the better memory management.

    What I’m saying is that you should be aware that you might run into strange problems that can be caused by the use of the 64 bit platform. Most of them are to be solved relatively simple but sometimes you may run into something that only exists in the 32 bit environment.

    Happy Coding

    Comment by Henrik Sørensen, DK — February 16, 2009 @ 1:27 pm

    • Hi Henrik,

      Thanks for the clarification and I have made a note about the potentional minor issues.

      Kind regards,

      Comment by Dennis Wallentin — February 16, 2009 @ 3:05 pm

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: