Trouble discovering vWorkspace database with Foglight running SQL Server 2012 R2

Had some issues today when setting up vWorkspace foglight against SQL Server 2012 R2, whatever I tried I always to the error message

Invalid Object name “trace_xe_action_map”

The problem is that SQL Server 2012 R” changed the trace_xe_action_map from dbo. to sys. In order to fix this we need to run a script on the vWorkspace database (or create a alias for it)

Run the query CREATE SYNONYM dbo.trace_xe_action_map FOR sys.trace_xe_action_map;

image

And voila!

image

#vworkspace