Solved

Sharepoint Question (Cost and Alternatives)

Posted on 2014-01-10
12
277 Views
Last Modified: 2014-01-13
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?

John
0
Comment
Question by:pepps11976
12 Comments
 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 250 total points
ID: 39770979
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?
0
 

Author Comment

by:pepps11976
ID: 39771008
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
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39771038
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
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 26

Expert Comment

by:Shaun Kline
ID: 39771050
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.
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39771054
0
 

Author Comment

by:pepps11976
ID: 39771067
So just to clarify then, You cant show nice Bar Graphs etc using the Foundation Version?

JOhn
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39771094
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.
0
 

Author Comment

by:pepps11976
ID: 39771101
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?

John
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39771120
No real drilling.  Also, everything would be designed outside of SharePoint.
0
 

Author Comment

by:pepps11976
ID: 39771189
So is there a Web App Or something to plug Into sharepoint?

And will it be able to be Real Time?
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39771220
It's called the SSRS add-in.  Download and install on web servers.

I do not believe it's real time.
0
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 250 total points
ID: 39773705
Hi,
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.

HTH
Rainer
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SharePoint 2013 Emulating SharePoint 2010 8 89
SharePoint CAML Query - retrieving field names 3 95
Set cookies HttpOnly and Secure 4 211
SharePoint Online Security 5 81
I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question