Blog Post

SQL Server Support Blog
5 MIN READ

Why do I get the infrastructure error for login failures?

mssql-support's avatar
mssql-support
Icon for Microsoft rankMicrosoft
Jan 16, 2019
First published on MSDN on Jul 09, 2016 In the past few weeks, I saw this error come across quite a bit and thought I will provide an explanation for the reasons why we gen...
Updated Jan 16, 2019
Version 2.0
errors
security
SandraV's avatar
SandraV
Copper Contributor
Dec 12, 2024

I know this is 3 years old but it might help someone searching for a solution.  I had the same issue as shaunjstu. In my case, I found that the user experiencing the connection problem was in yet another Windows Group that had CONNECT SQL denied.  Once I switched to GRANT, the user was able to successfully connect.