Cannot find MICROSOFT##SSEE instance and/or connection

Wayne88
Wayne88 used Ask the Experts™
on
I am trying to resolve an issue that's being shown on the event log as stated in this post but I can't see the existence of MICROSOFT##SSEE instance via SQL Server Configuration Manager or SQL Server Managemen Studio Express.  This is for SBS2008 machine and all the apps were pretty much installed with default settings.

Am I missing something here?  Please provide detailed steps on how to get to the MICROSOFT##SSEE settings.  Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2014
Commented:
Try below...

1.Open the SQL Management Studio Express.  If this is the first time you've opened SQL MSE, you will be prompted to enter a server name and select an authentication method.

2.In the server name box, type \\.\pipe\mssql$microsoft##ssee\sql\query.

3.Set the authentication to Windows Authentication.

4.Press Connect.
Top Expert 2015

Author

Commented:
Thank you, that worked!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial