I want my normal (role public) user123 (SQL Auth, not PAD, not sysadmin) to login to SQL Server 2019 (Developer version).
And I still get this error:
Login failed for user 'user123'. Reason: Login-based server access validation failed with an infrastructure error. Login lacks connect endpoint permission. [CLIENT: 127.0.0.1]
Error: 18456, Severity: 14, State: 149.
When I give user123 sysadmin role, then he connects. But I don't want him to be sysadmin. In fact, I want two separate application to connect to the database with user123 credentials as standard public user. But actually even one application can't connect.
There's a list of permissions: List of DB permissions
Any help and suggestions highly appreciated.
SOLUTION FOUND: Port in SQLDriverConnect() function shall be 1433 (default SQL instance) not 1434 (DAC Connection), with proper permission for public role on particular database (Connect, Select, Insert, etc.).
From the error message and the screenshot, I suspect that you might be connecting to the DAC rather than to the main SQL instance.
Please recheck your connection string in the application - or test using SSSMS
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句