A. Set a linked server (analysis server) in your SQL Server In the SQL Server Surface Area Configuration enable 'Ad Hoc Remote Queries' 1. Open SQL Surface Area configuration 2. Go to Database enginer --> Ad Hoc Remote Queries --> Set Enable OPENROWSER
Read More...