Can I run SharePoint Foundation on my existing SQL Server?

Posted on 2011-03-16
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?

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 50 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Drivers  Repository for Win 7 13 70
External Hard drive not accessible 4 35
Copying ALL contents of a thumbdrive with confidence. 3 34
Error  Dell Equalogics 2 20
Concerto Cloud Services, a provider of fully managed private, public and hybrid cloud solutions, announced today it was named to the 20 Coolest Cloud Infrastructure Vendors Of The 2017 Cloud  (…
The business world is becoming increasingly integrated with tech. It’s not just for a select few anymore — but what about if you have a small business? It may be easier than you think to integrate technology into your small business, and it’s likely…
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…

809 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