Cannot connect with Sql Server Studio: error 18456, state 8 -- but password is correct
Fresh3 days ago
Mar 15, 202610899 viewsConfidence Score0%
0%
Problem
Using Sql Studio Express (on a Windows 7-64 machine) to connect to three different Sql Server 2005 servers using Sql Server Authentication, I'm getting Error: 1846, State: 8. According to Link, this should be password mismatch. Yet, when I use the same user names and passwords from SQLCMD and from …
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Cannot connect with Sql Server Studio: error 18456, state 8 -- but password is correct
Low Risk
I would try the following things in this order of difficulty: Before anything, I would try that 10.19.190.x IP address with the instance name: 10.19.190.x\instance_name, also by servername. I suspect it may be a protocol issue (more on this below), …
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix