Unable to login remotely to MSSQL2005 Express instance (Error 18456)

Posted on 2008-11-10
Last Modified: 2012-05-05
I am unable to login to a SQL Server Express 2005 named instance on my server remotely.  I get the error message "Login failed for 'USERNAME'" in SSMS.  I have used the Surface Area tool to enable remote TCP connections (I've also tried Named Pipes).  

In the ERRORLOG, I get 'Error: 18456, Severity: 14, State: 8'.  According to, State 8 means 'mismatched password' but I absolutely know this is not the case, as I can login to the local SSMS using the same credentials.

Also, if I try a test from the Administrative Tools >> Data Sources (ODBC) window, the test comes back successfully.

Can anyone help?

Question by:jimbobmcgee
    LVL 7

    Expert Comment

    Attached is the Screenshot. go Sql Server Configuration Tools. and open surface configuration tool.
    Please See the Screenshot and enable the Remote connections.

    LVL 16

    Author Comment

    From my initial post:

    "I have used the Surface Area tool to enable remote TCP connections (I've also tried Named Pipes)."  
    LVL 16

    Accepted Solution

    Looks like it was an issue with my Management Studio.  I was able to connect remotely from another machine, so I reinstalled SSMS on mine and it connected OK.

    Maybe it's a limitation of SSMS Express (the one I reinstalled was SSMS Dev)?

    Either way, I'm sorted.  Thanks.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    755 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

    24 Experts available now in Live!

    Get 1:1 Help Now