Sharepoint Question (Cost and Alternatives)

We have a Customer that would like the ability to Control Documents etc.
They would also like to be able to show Graphical Charts pulled from SQL Server to show on SharePoint Pages.

Please can somebody Suggest Licence Requirements and Costs that will be needed as I have no idea.

Also I know that share point Foundation is Free but does no have the ability to use Business Intelligence, so if the Cost for them to implement SharePoint Enterprise is to much are there any Alternatives.

Also am I correct in saying that SharePoint Installed on the same machine As SQL does not require a License?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Justin SmithSr. System EngineerCommented:
SharePoint Foundation doesn't require a license, whether it's on the same machine as SQL or not.  SQL Express doesn't require a license, whether it's on the same machine as SharePoint or not.

The Graphical charts, are these items that will be coming from an existing SSRS instance that will just live in SharePoint?  Or are you wanting to build charts from within SharePoint or have a new SSRS instance dedicated to SharePoint?
pepps11976Author Commented:
The customer Already has SQL Installed.

They like the idea of SharePoint for Document Management etc., but they would also like to Build Graphical Charts And Graphs which I assume You need to have SharePoint Enterprise installed??

So I was after an idea of license Costs and if there were any Cheaper alternatives
Justin SmithSr. System EngineerCommented:
To get costs you need to speak to a vendor like CDW or Dell.

If they already have an SSRS instance and have developers to make reports, you can house them in Foundation, you don't need the full version.

However, if they are looking to do any development or drill down within the browser, they will likely need the full Enterprise edition
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

Shaun KlineLead Software EngineerCommented:
Just add clarification, SharePoint Foundation (at least the 2010 version) has specific requirements for the server it is installed on and the SQL Server that it interacts with. The server that will run SharePoint must be at least Windows 2008 R2 64-bit or greater and paired with SQL Server 2008 R2 on a 64-bit server (or greater). To my knowledge, SharePoint will not work with an Express version of SQL Server. Also, take are to read the licensing for SQL Server as you may incur CAL requirements, both for SQL Server and the Windows machine running it.

You can also build custom pages / components for SharePoint using Visual Studio, but this is not as simple as doing web page development.
Justin SmithSr. System EngineerCommented:
pepps11976Author Commented:
So just to clarify then, You cant show nice Bar Graphs etc using the Foundation Version?

Justin SmithSr. System EngineerCommented:
You can display a static report that was made in SSRS, sure.  But if you are looking to create stuff in the browser based on data in SharePoint (Performance Point), you will need full version.
pepps11976Author Commented:
Ok Thanks so by Saying Static Foundation would not be able to automatically update it without user integration?

Or do you mean Static as in no Drill Downs?

Justin SmithSr. System EngineerCommented:
No real drilling.  Also, everything would be designed outside of SharePoint.
pepps11976Author Commented:
So is there a Web App Or something to plug Into sharepoint?

And will it be able to be Real Time?
Justin SmithSr. System EngineerCommented:
It's called the SSRS add-in.  Download and install on web servers.

I do not believe it's real time.
Rainer JeschorCommented:
first of all: SharePoint Foundation needs licenses! It needs proper Windows licenses / CALs. Due to the fact that in a corporate environment each and every user already has a Windows CAL for all other kind of services, it looks like SharePoint Foundation is free of licenses - which is just half of the truth.
For anonymous / internet access the SharePoint web frontend server needs a proper internet connector license (Windows).
And there is a huge difference between SharePoint Foundation 2013 and 2010: in the latest version all "named external" users do no longer need a license - hence if you have customers / partners / all kind of named /known user which are not employees, then no additional license necessary (which is in 2010).
Afaik SQL Server Express does not need licenses but has some dramatic limitations (depending on the exact version) - mainly the maximum database data file size (2005/2008: 4GB, 2008R2/2012: 10GB) and the max RAM usage of 1GB.
Of course can you reuse the existing SQL Server - but that one has to be setup properly for SharePoint - from my experience in 85% of all performance issues it was the badly configured SQL server.
For charting:
What type of charting do you mean? There are so many different ways like:
- SQL Server Reporting Services(*1)
- Performance Point Services (*2)
- Visio Services (*2)
- Javascript Charting Frameworks
(*1) - Not with SQL Server Express
(*2) - Needs SharePoint Enterprise CAL

So depending on your development skills and exact requirements, I would suggest to use SharePoint Foundation 2013, the existing (full) version of SQL Server and some custom programmed web parts which load the data from SQL Server and then using charting frameworks like gRaphael, jgPlot ... to render the data.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.