troubleshooting Question

Cannot log into SQL instance. \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

Avatar of Eirejp
EirejpFlag for Japan asked on
Microsoft SQL Server 2005SBS
10 Comments1 Solution6974 ViewsLast Modified:
Hi,

Having a few issues logging into the internal database.

Background is I am getting a lot of 17137 errors in the event log on my sbs2008 box.
Tried to follow this guide to resolve it: http://chrisdill.wordpress.com/2010/11/03/event-id-280/

When I try to login to the SQL Management Studio Express I get the follow error

 
 loginscreen
I then get the following error messege:
TITLE: Connect to Server
------------------------------

Cannot connect to \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query.

------------------------------
ADDITIONAL INFORMATION:

Login failed for user 'Administrator account'. (Microsoft SQL Server, Error: 18456)


Another odd thing I noticed is when I go to the surage are configuation tool and change Local connections only -> Local and Remote using both TCP/IP and named pipes after I reset the service and reopen the tool it is back to Local Connections Only.




ASKER CERTIFIED SOLUTION
Nat Wallis
Technical Services Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 10 Comments.
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>

Mike

Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 10 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004