hi,

i know it is an old thread but i am having the same issue. I tired giving select permission to public on sys.configuration but still getting the same error message

"The SELECT permission was denied on the object 'configurations', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)"

can there be any other reason??

thanks