Question

Sharepoint Suitability for Small Business Intranet

Asked by: redpoppy

Hello Experts,

I would like to ask for some advice on the suitability of using Sharepoint Services to create an intranet for our small business. Our current setup is Windows  Server 2003 using Office 2003, currently with a maximum of 8 users. My role would be the design and implementation of the intranet  I have experience in web design using DreamWeaver/HTML and programming in VB using MS Access. The features that I think wed initially want on the intranet are as follows:
 
1) Centralise documentation (eg: Procedures, Standard E-mails held in HTML, output by an MS Access database).
2) Users to be able to maintain these documents. Some are WORD but some are HTML, so there would need to be a WYSIWYG editing facility (at the moment we use Adobe Contribute)
3) Creation of  a work timetable of whos working, when, and a system to schedule meetings
4) Daily task list specific to the person signing in  which might  include feeds from the MS Access database of any Quotes/Bookings marked for their attention or e-mails from Outlook.
5) Creation of management reports/graphs/charts from MS Access d/base input

My questions are:
1)  Would Sharepoint be a good solution or is it a bit over-the-top for such a small business?
2)  What other software would be required to install Sharepoint?
3)  If its suitable, from what I can make out wed need version 2.0 with our set up  is that correct?
4)  What are the cost implications  or is Sharepoint free? Im a bit confused from what Ive read so far.
5)  Given my programming background, can you give me some idea of the potential learning curve that I might go through to design/implement such a system, if its feasible

Any help/advice will be much appreciated.

This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

  • Plus...
  • 30 Day FREE access, no risk, no obligation
  • Collaborate with the world's top tech experts
  • Unlimited access to our exclusive solution database
  • Never be left without tech help again

Subscribe Now

Asked On
2009-05-14 at 03:37:33ID24407911
Tags

Microsoft Sharepoint Services

,

Intranet

Topics

MS SharePoint

,

Windows 2003 Server

Participating Experts
2
Points
500
Comments
6

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

  • "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
  • "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
  • "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Screenshot of Experts Exchange Knowledgebase

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Screenshot of an Article

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Screenshot of Experts Exchange Knowledgebase

Access the answers to your technology questions today.

Subscribe Now

30-day free trial. Register in 60 seconds.

What Makes Experts Exchange Unique?

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Trusted by the world's most respected brands.

image of each brand's logo

Faithfully serving IT professionals since 1996.

Experts Exchange Logo

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

Related Solutions

  1. Sharepoint intranet site
    Hi, I want to create a sharepoint intranet site with the following on the site; can this all be achieved using an out-of-the-box solution? If so, which sharepoint webparts would I use for each of the below? Discussion Forums (Discussion Alerts via email) Latest News Techn...
  2. Sharepoint Intranet Question
    We are converting an HTML intranet to Sharepoint WSS. Our employees are not used to online collaboration, so we thought we might integrate Sharepoint over time. We're also introducing a new look and feel, new navigation, etc. and don't want to use the "out of the box&quo...
  3. AJAX requests to retrieve RSS feeds of SharePoint blogs
    I am trying to get AJAX to access the RSS feed of a SharePoint blog. From what very little I understand about SharePoint, it uses the credentials that are how you log into Windows, so the issue is that when my web application sends the request, those credentials are not sent...
  4. Is it possible to use Dreamweaver with Sharepoint
    I know you are scratching your heads and wondering why on earth would I want to do that, well simple truth is Dreamweaver is easier. So is there a way to use dreamweaver with Sharepoint.
  5. RSS feed from SharePoint
    I created few announcements, tasks and events in the calendar in sharepoint 2007. How can I receive these into outlook 2007 as a rss feed. RSS is enabled in the site level.
  6. Moving ASP Intranet to Sharepoint
    Hi, I have developed an Intranet in ASP which holds a lot of company data and documents. The documents are stored physically with only the paths and file names stored in the database. The company want to move to a Sharepoint platform for better Office integration and I hav...

Free Tech Articles

  1. WARNING: 5 Reasons why you should NEVER fix a computer for free.
    It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
  2. SCCM OSD Basic troubleshooting
    SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
  3. Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
    This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
  4. Create a Win7 Gadget
    This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
  5. Outlook continually prompting for username and password
    There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
  6. Backup Exchange 2010 Information Store using Windows Backup
    There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...

Cloud Class Webinars

  1. Avoiding Bugs in Microsoft Access
    Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
  2. Top 10 Best New Features in Visio 2010
    Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
  3. IT Consultant Business Secrets Revealed
    Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
  4. Disaster Recovery and Business Continuity
    Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
  5. Organize Your Visio Diagrams with Containers and Lists
    Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
  6. How to Us Objects, Properties, Events and Methods in Microsoft Access
    Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

Join the Community

Answers

 

by: DhopePosted on 2009-05-14 at 04:50:28ID: 24383791

1) I don't think it'd be OTT, and given a small company you'd be able to ensure a swift move to using it.  Our environment is not large but has 400 users and some people love SharePoint, others still haven't a clue what it is so the uptake varies wildly.

2) From a desktop point of view then Office 2007 would be better, but 2003 is adequate to allow people to modify lists in datasheet view, check documents in and out easily and to integrate tasks with Outlook etc.
 SharePoint version 2?  Would think WSS 3 would be fine - http://technet.microsoft.com/en-us/windowsserver/sharepoint/bb684453.aspx
To see differences between SPS2 and WSS3 have a look at
http://technet.microsoft.com/en-gb/windowsserver/sharepoint/bb400755.aspx

4) Windows SharePoint Services (WSS) is free.  Microsoft Office SharePoint Services (MOSS) isn't.
To see differences between WSS and MOSS have a look at
http://office.microsoft.com/en-us/sharepointtechnology/FX101758691033.aspx

5) It's fairly quick to get used to.  I came from a desktop & server support background, knew enough about HTML, C# etc to be able to read what others had done but struggle to write things from scratch myself.
Because you have an understanding of DBs, some coding, some HTML, plus probably some desktop and server support then I don't think you'll struggle gettings things up and running.

 

by: screen-namePosted on 2009-05-14 at 15:28:05ID: 24390567

There is also the cost of the database, and I would not suggest putting production data on SQL express, or windows internal database.  (your choises are WID, SQL express, or $QL)  Plus the cost of backing up that DB, and the proper set of the DB, Sharepoint can kill a DB server in a heartbeat if not setup properly.

Also, there is MS Search server express, I would suggest running it seperately from WSS, and its not needed if you go with full blown MOSS.  But it gives you alot of the MOSS features scaled down a bit.

To really do sharepoint right, you really need to know C#, its a must, Now, you might be able to get away with out all that knowledge simply because of the smal user base, your code wont NEED to be as efficient as enterprise code does.

There are also a lot of 3rd party apps that make things easier, my personal suggestions, got to:

www.codeplex.com - search sharepoint
www.nintex.com - Drag and drop WYSIWYG Workflow design.

Alos, if you did go with sharepoint, I would try to get out of the access DB mantality, user WSS custome lists instead.

But the best Idea would be to piick several collaboration platforms and running a pilot with the actual users and ask them what they like.

Also, DO NOT USE anything older than WSS3.0 - There not point, WSS3 is free, MOSS 2007 is not free, and dont forget about the DB server you'll need.

Make sure if you bring in a SQL DBA that he/she has experiance with Sharepoint and SQL, its a totaly different world for them, there are things that you just dont do with Sharepoint DBs, that is normally part of the SQL DBA toolset.


 

by: redpoppyPosted on 2009-05-15 at 01:46:30ID: 24393300

Hi Experts,

Thanks for your comments, the links were very useful.

As I've been researching, the more confused I'm getting - it seems like there could be quite a few pitfalls with Sharepoint (not least of which could be performance problems on the server) and that I would need help from an experienced Sharepoint developer - is that fair comment, do you think?

I have  come across another couple of options as I've been looking around - the open source Joomla (http://www.joomla.org/) and an off-the-shelf, Denali (http://www.denaliintranet.com/default.aspx) - do you think either of these might offer a simpler approach?

Thanks again for your help.

 

by: DhopePosted on 2009-05-15 at 05:29:27ID: 24394705

Never heard of Denali, but the website looks hideous :)
I know it's very superficial, and it may be wonderful to use, but I'd be very skeptical if someone asked me to start using something that looked like it'd been written in Frontpage 10 years ago.

Joomla could be worth a go, it's certainly popular and has a lot of community support.  For a list of some sites that use it for an intra/extranet see http://forum.joomla.org/viewtopic.php?f=48&t=264734

Both Joomla and SharePoint are very easy to get set up and working without specialist knowledge.  I'd suggest getting a workstation of a decent spec, run up a couple of VMs and see which you like the look of.  My desktop at home is a Core2 Quad 3.2GHz, 8GB RAM and it runs WSS 3.0 on Server 2008 using VMWare without any problems at all.  If I wanted to get used to Joomla I'd just install it there too and see what I thought of it.

 

by: screen-namePosted on 2009-05-15 at 06:21:05ID: 24395151

There is also, Office Live - might be a bit over simplfied, http://www.officelive.com/?xid=9C9BC755-9EDD-4933-9C66-D3FC066B6283&WT.srch=1

IMHO, if you have eight users, and you have sharepoint performance problems, you have done something terribly wrong... But thats just me.... :)

Any sort of high quality Collaboration suite is going to require that an expert be involved in some way shape or form...

The reason to use sharepoint would be that you like MS products, less training, Office intergration, and future releases, Some of these open source COLLAB projects may or may not last, MS will be around for quite some time.  

But no matter what platform or app you chose, make sure the person responcsble for supporting it needs to dive in head first and learn the system up and down.  These systems are not just "web sites" they are "web applications"  thus needing much more expertise in programming IMHO....

I am an Admin, but I know what my developers are worth.

 

by: redpoppyPosted on 2009-05-16 at 11:52:18ID: 31581375

Thanks for the info - each answer gave me something else to think about and the links were very useful. I haven't yet come up with a solution, but there's now plenty of food for thought.

20120131-EE-VQP-002

3 Ways to Join

30-Day Free Trial

The Experts

98% positive feedback on 31,087 answers since March 2000. angeliii is a Microsoft Most Valuable Professional for his work with MS SQL Server & Develoment.

He has also proven his knowledge of Visual Basic Programming, PHP Scripting and Oracle Databases.

The Experts

97% positive feedback on 10,752 answers since July 2000. lrmoore has more than 18 years experience in the networking industry.

The six-time Mircosoft MVPs specialties include firewalls, virtual private networking, and network management.

Testimonials

"...and excellent source for support... Kind of like having your very own IT dept." Electriciansnet

Testimonials

"I was apprehensive at signing up at first. However... it has already made my life as an IT administrator much easier." JaCrews

Testimonials

"WOW! You guys have great, active, and knowledgeable people on here." moore50

Business Clients

Business Clients

In the Press

"If you’ve got a question... Experts Exchange can supply an answer.”

In the Press

"...an invaluable aid for both IT professionals and those who require tech support."

In the Press

"where IT professionals provide quick answers on just about any topic"

Business Account Plans

Loading Advertisement...