I have setup a test Analysis and DB Server. I was wondering, how could i do a full processing of my cube pointing to the test server and not the production? Is there a setting on the AS Server, where i point to my test db server not the prod? Appreciated if someone please suggest. Thanks, Cali
Hi, Open SSMS, connect to AS server and then expand AS DB in LHS tree. Select the data sources folder and open the datasource created by right clicking on the same and select properties. Check the connection string and modify it to point it to your test server.