November 21, 2011 at 12:03 am
hi dude, check it u r entering password correctly and also check the following
Error: 18456, Severity: 14, State: 8.
Base on the Error state u can identify the error correctly.
ERROR STATEERROR DESCRIPTION
2 and 5Invalid userid
6Attempt to use a Windows login name with SQL Authentication
7Login disabled and password mismatch
8Password mismatch
9Invalid password
11 and 12Valid login but server access failure
13SQL Server service paused
18Change password required
🙂
November 21, 2011 at 12:55 am
jp.sqldba (11/21/2011)
hi dude, check it u r entering password correctly and also check the followingError: 18456, Severity: 14, State: 8.
Base on the Error state u can identify the error correctly.
ERROR STATEERROR DESCRIPTION
2 and 5Invalid userid
6Attempt to use a Windows login name with SQL Authentication
7Login disabled and password mismatch
8Password mismatch
9Invalid password
11 and 12Valid login but server access failure
13SQL Server service paused
18Change password required
🙂
It looks familiar. Didn't I post it already? 😉
May 7, 2014 at 3:49 am
Hi
I also tried to search a right solution for successful login in SQL Server but there is no solution available then i try third party tool for sql password recovery.
SSMS Expert
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply