Solved

Cannot find MICROSOFT##SSEE instance and/or connection

Posted on 2014-02-27
2
295 Views
Last Modified: 2014-02-27
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.
0
Comment
Question by:Wayne88
2 Comments
 
LVL 13

Accepted Solution

by:
Santosh Gupta earned 200 total points
ID: 39893438
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.
0
 
LVL 13

Author Closing Comment

by:Wayne88
ID: 39893476
Thank you, that worked!
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now