Try to create pivot table reports and get error message:
"Cannot connect to DynamicsGPWarehouse on server xx"
However, in Management Studio, I can successfully execute a query against the DynamicsGPWarehouse database. Appears to be some kind of permissions problem, but I am using the sa user. Any ideas?