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
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.