Tag: MICROSOFT##​SSEE


How to connect ​MICROSOFT##​SSEE

Problem:

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!

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…
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.
 put\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

as the server name.

Reference: http://channel9.msdn.com/Forums/TechOff/255490-How-to-connect-MICROSOFTSSEE