Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

SA login question. Expand / Collapse
Author
Message
Posted Thursday, November 21, 2013 12:18 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:27 AM
Points: 7,004, Visits: 8,449
According to this overview state 1 means your login (i.e. sa) is disabled.

Troubleshooting Error 18456
http://sqlblog.com/blogs/aaron_bertrand/archive/2011/01/14/sql-server-v-next-denali-additional-states-for-error-18456.aspx

Error: 18470, Severity: 14, State: 1.
Login failed for user '<x>'.
Reason: The account is disabled.


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1516550
Posted Thursday, November 21, 2013 2:20 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:10 AM
Points: 273, Visits: 855
What is in the SQL server error logs for these failed login attempts?
Post #1516583
Posted Thursday, November 21, 2013 11:47 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 16, 2013 11:53 PM
Points: 31, Visits: 92
Hi Johan,

Yes, But, both the sa and my test account are enabled and I can connect to both from another server.

Here is the SQL error log details:

Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]

Error: 18456, Severity: 14, State: 8.

This is a very strange issue. At first I thought it could be privileges on my windows account, after confirming that I am an admin it was clear that wasn't the issue.

I can't find anything on the net related to this specific issue.

Any help would be appreciated

Thanks
Post #1516653
Posted Friday, November 22, 2013 3:27 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 16, 2013 11:53 PM
Points: 31, Visits: 92
These timezones really suck. Any one awake that have suggestions?
Post #1516707
Posted Friday, November 22, 2013 8:56 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:10 AM
Points: 273, Visits: 855

How are you trying to connect from the local machine to the SQL server?
SSMS or is it a application?

Post #1516833
Posted Friday, November 22, 2013 9:13 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 16, 2013 11:53 PM
Points: 31, Visits: 92
SSMS
Post #1516848
Posted Friday, November 22, 2013 9:38 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:10 AM
Points: 273, Visits: 855

Have you typed the password out in a text editor and then copied and pasted it into the login window?
Are the SSMS the same version on both servers?
Same OS patch level?
Anything weird about character sets or localizations?

If you use the wrong password (on purpose) on the second server, do you see the failed login entry in the SQL Server error log?
Post #1516859
Posted Sunday, November 24, 2013 11:14 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 16, 2013 11:53 PM
Points: 31, Visits: 92
Yes
Yes
Yes and
No, character sets are same on both servers

I have also tried a incorrect password on the 2nd server and it threw out the same error in the alert log.
Post #1517156
Posted Monday, November 25, 2013 10:28 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 16, 2013 11:53 PM
Points: 31, Visits: 92
Is there anyone with any more ideas/suggestions? Or anyone who has experienced this before?

Regards
Post #1517528
Posted Wednesday, November 27, 2013 12:58 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 16, 2013 11:53 PM
Points: 31, Visits: 92
Is it possible that registry entries could cause this? Or would reinstalling SSMS fix this? I don't want to try to many things as this is a live environment
Post #1517926
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse