How can we help you today? How can we help you today?

SQL Permission Error Connecting to Server (SQL Test)

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
jschwartz6818
0

Comments

2 comments

Sort by
  • Rob C
    Sorry to hear that you're experiencing this. Could you run GRANT EXECUTE ON sys.xp_qv TO username? That would be a quick fix.
    Rob C
    0
  • jschwartz6818
    Thanks Robert. That was close but I also had to grant execute permission on another one. Here are both commands that solved my problem:

    GRANT EXECUTE ON sys.xp_qv TO [login]

    GRANT EXECUTE ON sys.xp_instance_regread TO [login]
    jschwartz6818
    0

Add comment

Please sign in to leave a comment.