I am using the lite sharepoint version 2008 and the trickiest thing for me was figuring out how to connect to the database. Figured out that Windows Sharepoint Services (WSS) 3.0 ship with SQL Server 2005 Embedded Edition. Now called the Windows Internal Database.
Steps for connecting to the internal SSEE database:
- Open us Microsoft SQL Server Management Studio 2008
- Server Name: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
- Use Windows Authentication
More information can be found here.