When right-clicking on a table and selecting "select top 1000 rows", I get this error:
Is there any workaround, other than the obvious upgrade to SQL Server 2014?
SQL Server 2014 – View Server State Permission Denied Error
connectivitysql serversql server 2014sql-server-2012ssms
Related Solutions
It's pretty likely you were using RC0, which expired a few days ago. I would imagine that if you start and stop the 2012 engine service in the services control panel, then it will refuse to start again.
When you have reinstalled Express it will be fine.
I fixed the same symptoms/issue (which surfaced after I reinstalled the Visual Studio 2010 Isolated Shell, on which SSMS depends as a component) by removing the 2010 Visal Studio Isolated Shell and then repairing SSMS 2014 (download SSMS 2014 SP1 from here):
Related Question
- Sql-server – SQL Server 2014 and SQL Server 2014 Management Studio
- SQL Server Management Studio – Slow Connection or Timeout with Windows Authentication
- Sql-server – SQL Server 2014 Management Studio Backup error
- Sql-server – How to fix SQL Server Management Studio 2014 IntelliSense when intermittent
- Sql-server – Error when upgrading SQL Server from 2012 (sp3) to 2014
- Sql-server – Can’t Dump Database Because MS SQL Server Management Studio Won’t Show Any Databases If 1 Is Permission Denied
Best Answer
Just for reference, this problem seems to be related to this Connect bug:
Cannot view properties of database when using db owner account - by Jimmy Rudley
I have the same problem with SQL Server 2012 Management Studio 2012.
If anyone finds themselves stuck with this problem, try to update SQL Server Management Studio. This way, you don't need to grant the permission
VIEW SERVER STATEto the user.Using SQL Server Management Studio 2014 (12.0.4213.0) now, and the problem seems to be gone.