• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 757
  • Last Modified:

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

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 http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx, 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?

J.
0
jimbobmcgee
Asked:
jimbobmcgee
  • 2
1 Solution
 
efg-uaeCommented:
Attached is the Screenshot. go Sql Server Configuration Tools. and open surface configuration tool.
Please See the Screenshot and enable the Remote connections.
 
 

sql2005.JPG
0
 
jimbobmcgeeAuthor Commented:
From my initial post:

"I have used the Surface Area tool to enable remote TCP connections (I've also tried Named Pipes)."  
0
 
jimbobmcgeeAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now