[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2008-11-10
3
Medium Priority
?
744 Views
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 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
Comment
Question by:jimbobmcgee
  • 2
3 Comments
 
LVL 7

Expert Comment

by:efg-uae
ID: 22927847
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
 
LVL 16

Author Comment

by:jimbobmcgee
ID: 22929251
From my initial post:

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

Accepted Solution

by:
jimbobmcgee earned 0 total points
ID: 22929837
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
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…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

873 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