Can I run SharePoint Foundation on my existing SQL Server?

Posted on 2011-03-16
Medium Priority
Last Modified: 2012-06-27
I am planning to install SharePoint Foundation in my organization. I do have existing SQL Server 2008 R2 Workgroup in place. Can I use it as a DB server for SharePoint?
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 35153510
I think the main issue may be database collation.  SharePoint uses a specific collation.  And if all DBs are created using the WebUI, then from what I have seen, SharePoint will create the DB in the correct collation.  But when "pre-creating" DBs(generally recognized as a best practice), you will have to select the correct collation, or SharePoint will reject it.  What implications this has is the long term, I do not know.

In more general terms, are you sure your existing SQL server can handle the extra load from a SharePoint implementation?  SharePoint uses almost everything SQL has to offer, and uses it heavily.  

Also, diskspace can be a concern, pre-creating and locking growth on your DBs may need consideration.  If you are connected to a SAN, I would put the SP DBs on a separate LUN from the other DBs this server houses.  On local Storage, you'll need to watch your DB growth carefully, and manage site collection quotas accordingly.  But that is stuff that should be getting done anyway.

You will also need to make sure your SP service accounts have the proper permissions to the DB server, but again, you would run into that using a dedicated DB server too...

A few resources...




Author Comment

ID: 35153541
At this point space requirement is not my concern, I have a new 24TB SAN. I was just wondering if Foundation has an option to chose external SQL server and if so what version? Is Workgroup good enough or it needs to be Standard or higher. I want to share SQL server with our account solution which we are planning to get.
LVL 10

Expert Comment

ID: 35156009
With regards to collation, you can create databases that inherit the instance collation or have their own.  I don't see that being an issue.

Running SQL and SharePoint on the server is generally not best practice (I think the prerequisite checker might throw a warning) but it's certainly doable and should cause you no issues initially.  Just make sure that your machine can handle the grown and the disk activity.

As part of the SP installation and configuration process (run after bonaries are dumped on server) you can specify the server/instance you want to use.  I don't think there is any limit on which version as long as it's a 64bit edition.  Since foundation/2010 is 64bit only you should be placing it on a 64bit machine with 64bit SQL anyway?
LVL 15

Accepted Solution

sharepointguru14 earned 200 total points
ID: 35172670
I believe your question was could you just use the existing sql server not run sp foundation on the server itself right. In other words you are going to have a SharePoint server and your sql server? Either way the answer is yes although I wouldn't recommend the 1 box solution especially if your using sql for other things.
With sql 2008 R2 you are good to go. Workgroup only limits you to the features that are available in workgroup. For example I don't think that has reporting services so the reporting features of sharepoint are not going to work. BUt for basic file collaboration you should be fine.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
Is your phone running out of space to hold pictures?  This article will show you quick tips on how to solve this problem.
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

777 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