question

Gehima2016 avatar image
Gehima2016 asked

SQL Server 2016 not authenticating non sysadmin users

Hello,

I am currently having an issue with a newly installed 2016 SQL Server sitting on Windows 2016 server. The problem is that when a user is given a non sysadmin permission (such serveradmin or database role datareader) as on the server that user cannot login from the local PC but can login through the remote server. When a user with a non sysadmin permission tries to login from the local PC, the error below is thrown;

"The SELECT permission was denied on the object 'configurations', database 'mssqlsystemresource', schema 'sys'. (.Net SqlClient Data Provider)"

Error Number: 229
Severity: 14
State: 5
Line Number: 17

Please, I will appreciate if anyone has a clue what the problem is since I am considering reinstalling the SQL Server again. I want to exhaust my options before taking that route.

Thank you for reading this post.

permissions
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·

Have you checked to see if there are any DENY privileges configured?

0 Likes 0 ·
Gehima2016 avatar image Gehima2016 commented ·

Hi Thomas,

Thank you very much for reading my post.

There is no deny privileges. This is a brand new server which I have checked to verify.

0 Likes 0 ·
JohnM avatar image JohnM commented ·

Can you check to see if public permissions were dropped somewhere? I found a couple of articles mentioning public.

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.