Use the following connection string in SQL Management Studio while trying to connect SQL Database server running Embedded Edition :
\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
Applicable for SQL Server 2005 and SQL Server 2008
\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
Applicable for SQL Server 2005 and SQL Server 2008