SQL Permission Error Connecting to Server (SQL Test)
jschwartz6818
Posts: 3 New member
When I connect to my QA server, I have sysadmin permissions and everything works fine. I created an elevated account to connect to my UAT server and I connect properly. However, when I create the standard account for my development team (I have one myself), I get an error from SQL Test when I try to connect. I do NOT get that error from the same client session if I connect to a different server where I have sysadmin.
The SQL Test error simply says "Failed to retrieve data for this request". plus the SQL Server error says "The EXECUTE permission was denied on the object 'xp_qv', database 'mssqlsystemresource', schema sys. (Microsoft SQL Server, Error: 229)
I really don't want to grant sysadmin permission to all my developers on UAT and PROD.
Thanks
The SQL Test error simply says "Failed to retrieve data for this request". plus the SQL Server error says "The EXECUTE permission was denied on the object 'xp_qv', database 'mssqlsystemresource', schema sys. (Microsoft SQL Server, Error: 229)
I really don't want to grant sysadmin permission to all my developers on UAT and PROD.
Thanks
Comments
Redgate Software
GRANT EXECUTE ON sys.xp_qv TO [login]
GRANT EXECUTE ON sys.xp_instance_regread TO [login]