SQL Server Performance

Full cube processing.

Discussion in 'Analysis Services/Data Warehousing' started by california6, Dec 18, 2007.

  1. california6 New Member

    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
  2. ranjitjain New Member

    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.
  3. california6 New Member

    Ranjit,
    Thanks a lot. Followed what you suggested and it worked fine.
    Thanks again,

Share This Page