How to connect ​MICROSOFT##​SSEE

Hello Programms!

Sharepoint services 3 was install with default settings (with SQL Server 2005 Embedded Edition (MICROSOFT##SSEE)).

After that i setup SQL Server Management Studio Express. 

I cant connect to it DB, because connection to MICROSOFT##SSEE fault:
"...bla..bla..bla...MICROSOFT##SSEE does not allow remote connections.....bla..bla..bla..."

In SQL Server Configuration Manager i turn on everythink: tcp/ip, all clients protocol. Not help.

How to connect MICROSOFT##SSEE with SQL Server Management Studio Express?

Thanks!

Thanks a Lot Dude

1.

Open the "SQL server Configuration Manager", right-click the line "Protocols for MICROSOFT##SSEE" and choose "Properties". The "hide instance" field is set to "yes", put "no" instead, validate, and restart the microsoft##ssee service...

2. 
SQL Server Configuration Manager -->  SQL Native Client Configuration  ---> Aliases  --->  Right click on Alias name:  <servername>\Microsoft##SSEE --->  properties  --->   Change the Alias Name from <servername>\Microsoft##SSEE to <servername>\##SSEE.  

Worked & my Central Administration is working fine....
 
- PrashanthSpark
 Sharepoint Architect
 INDIA

Hi,
I went through the same problem, and finally managed to find a solution !

Open the "SQL server Configuration Manager", right-click the line "Protocols for MICROSOFT##SSEE" and choose "Properties". The "hide instance" field is set to "yes", put "no" instead, validate, and restart the microsoft##ssee service... You can know access the database with SSMSE !

Hope it'll help...

osaelen wrote:

Hi,
I went through the same problem, and finally managed to find a solution !

Open the "SQL server Configuration Manager", right-click the line "Protocols for MICROSOFT##SSEE" and choose "Properties". The "hide instance" field is set to "yes", put "no" instead, validate, and restart the microsoft##ssee service... You can know access the database with SSMSE !

Hope it'll help...

I had the same problem, but the difference was that instead of SQL Server Management Studio Express, I had installed the original SQL Server Management Studio (Not the Express one).  I solved the problem by going to SQL Server Configuration Manager -->  SQL Native Client Configuration  ---> Aliases  --->  Right click on Alias name:  <servername>\Microsoft##SSEE --->  properties  --->   Change the Alias Name from <servername>\Microsoft##SSEE to <servername>\##SSEE. 

http://channel9.msdn.com/ShowPost.aspx?PostID=345561#345561

...or put

\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

as the server name.

Thanks Mitch ,

this is the best solution

/*

...or put

\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

as the server name.

*/

I'm having a problem starting up my sql server 2005 windows internal database... this is the error I get:

The Windows Internal Database (MICROSOFT##SSEE) service failed to start due to the following error: Access is denied.

I just have AD installed on my Win 2k3 server. I am not running WSUS or SharePoint on this server