January 16, 2018 at 5:15 pm
Hi All ,
I have been facing login issue in our production server for a while
“Login failed for user 'Domain\xxx'. Reason: Attempting to use an NT account name with SQL Server Authentication.”
I checked in SSMS , this account is window account and Server authentication is mixed mode
How do I fix this issue ?
Any feedback are really appreciated
January 16, 2018 at 5:23 pm
WhiteLotus - Tuesday, January 16, 2018 5:15 PMHi All ,I have been facing login issue in our production server for a while
“Login failed for user 'Domain\xxx'. Reason: Attempting to use an NT account name with SQL Server Authentication.â€I checked in SSMS , this account is window account and Server authentication is mixed mode
How do I fix this issue ?
Any feedback are really appreciated
Don't type the user name and password. Select Windows Authentication, Trusted Connection or similar depending on how the connection is made from whatever client is being used to connect to SQL Server.
Sue
January 16, 2018 at 5:28 pm
Incidentally I was reading this article Understanding When SQL Server Kerberos Delegation is Needed. See if it describes your environment.
When you say you have been facing login issue, are you seeing login failure messages in Windows event or SQL Server error log?Have you been able to identify the client? Is the connection coming from SSMS or some application? What is the error message on the client's end?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply