sql server 2014

2024-05-06 07:21| 来源: 网络整理| 查看: 265

Window account is getting the below error when trying to connect into the SQL instance via management studio 2014.

The SELECT permission was denied on the object 'configurations', database 'mssqlsystemresource', schema 'sys' (Error 229)

The SQL instance is 2014, the user doesn't get the error if I make the login sysadmin.

The login has connect permission to the instance and even if i give it dbowner to the master database it cannot connect. Default database is master also. It is not an orphaned user I have tried the GRANT VIEW DEFINITION - no luck I have checked and the login doesnt have any DENY permissions

When i go into the properties of the login > Securables > effective tab > it gives the error:

The SELECT permission was denied on the object 'fn_my_permissions', database 'mssqlsystemresource', schema 'sys'.

So that is obviously related also

Any ideas?

【本文地址】

公司简介

联系我们