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.

image

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.

 

image

 

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

This entry was posted on 4/23/2009 01:58:00 PM and is filed under , . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.  

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)