SharePoint and SQL Server both goes together – hands to hand. SharePoint installation is very interesting. At various organizations, the installation is very different and have various needs. SQL Server installation with SharePoint is equally important and I have often seen that it is being neglected.
Microsoft has published the Deployment Guide for SharePoint Foundation. It talks about various database aspects as well.
For optimal sharepoint installation the required version of SQL Server, including service packs and cumulative updates must be installed on the database server. The installation must include any additional features, such as SQL Analysis Services, and the appropriate SharePoint Foundation logins have to be added and configured. The database server must be hardened and, if it is required, databases must be created by the DBA.
Deployment guide for Microsoft SharePoint Foundation 2010
Reference: Pinal Dave (https://blog.sqlauthority.com)
6 Comments. Leave new
Hi Dave,
The links are not working.
The links are working fine. What did you mean by not working?
Those links are not working
Hold control and then select the link. It will work then.
I can’t believe some people post things like this!… Apart from the fact that the links are self-referencing and don’t take you anywhere, the content of this article is merely the result of pasting very broad and high-level statements from MSDN pages… surely my grandma could do a better job!
Hi!
In the post-installation bliss, I decided to look out for good add-ons that people can use for their work. So far, I’ve found PowerPivot ).aspx) and Harmon.ie for SharePoint(http://harmon.ie).
Any suggestions what other general-purpose productivity tools I can get, preferably with free basic versions?