ms sql server error 18456 on sa login
-
Hello. I have a problem with sa login to ms sql server 2014 and 2008 on Windows 10. I have new computer with Windows 10. I am login to windows by domain user. When I installed MSSQL Server 2008 i had error 0x84B10001. I created local user and installed sql with him. When i loggin to windows by domain user i'm not login to sql by sa. I have error nr 18456 with state nr 8 (The password is incorrect). But when I'm login to windows by local user i can logi to sql by sa with the same password. What i'm doing to working sa login on the domain user?
-
Hello. I have a problem with sa login to ms sql server 2014 and 2008 on Windows 10. I have new computer with Windows 10. I am login to windows by domain user. When I installed MSSQL Server 2008 i had error 0x84B10001. I created local user and installed sql with him. When i loggin to windows by domain user i'm not login to sql by sa. I have error nr 18456 with state nr 8 (The password is incorrect). But when I'm login to windows by local user i can logi to sql by sa with the same password. What i'm doing to working sa login on the domain user?
Lots of possible causes for that error: MSSQLSERVER_18456 - SQL Server | Microsoft Docs[^] It sounds like your connection is using Windows authentication instead of SQL authentication. The full error message should give you more details.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
