Sharepoint and SQL Server connectivity?

Question

anybody knows why Sharepoint needs SQL Server, what is the connection between them?sm

Answer 1

Sharepoint ghosts all of its content into a SQL database. No content is stored on the file system, except some system layouts and application files. When you access SharePoint via the browser, or SharePoint designer the under system generates all files on the fly from the database.

This is done for performance, and back up benefits. There is no requirement to purchase SQL server - when deploying MOSS or WSS it will install SQL Express edition but limits you to only 4GB of software.

---

Follow Me on Twitter: @LewisBenge Or check out my blog: http://www.geekswithblogs.com/pointtoshare/

Answer 2

You are posting to an abandoned forum. (KN was in the BETA of MOSS 2007 and then dropped)


It is also only in the msdn set of SharePoint forums and not in the Technet set.


Post to a more suitable forum and you'll get a reply.

---

WSS FAQ sites: http://wssv2faq.mindsharp.com and http://wssv3faq.mindsharp.com
Total list of WSS 3.0 / MOSS 2007 Books (including foreign language) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx

Answer 3

SharePoint store all its data (like Sharepoint objects defination, its data and other inforation) into sql server database.

This link may be helpfull for you.

http://technet2.microsoft.com/Office/en-us/library/3e3b8737-c6a3-4e2c-a35f-f0095d952b781033.mspx?mfr=true