We have a few users that have a need to run some queries against a reporting database (not production). They just need a query window to query the databases on a server, using some prewritten views, and a few ad-hoc queries as needed. No local databases on their desktop.
What would be the best basic choice to install ? SQL Express ?
We are currently running SQL 2008 R0, with plans to upgrade to 2012 later this year.