Two DB with Standalone installation of SharePoint

Posted by Kasi Krishnamoorthy at 4/23/2009 01:58:00 PM


When I installed SharePoint on a standalone machine, it installed two different installation of SQL server

1. One is Embedded edition which stored the site content.  This database is located in Windows directory.  This one is running with service name of Microsoft##SSEE.


To connect to this use this as server name in SQL management studio:\\.\pipe\MSSQL$Microsoft##SSEE\SQL\query


2. The second installation for Search content and the location of the content DB is within 12 hives. This one is running with service name of OFFICESERVERS.




I am just wondering why do we need two instances of SQL server? We could have achieved with one SQL server instance. Any Idea?