Hi ..



I am using SQL Server 2000 as the Data Warehouse from my application.



My Analysis Services is connecting to the data source with the aid of
"Microsoft OLE DB Provider for SQL Server". Upon using this, the data
source takes the following name: <ServerName> - <DatabaseName>.



The issue is that while moving the OLAP database from the development to
the production environment, we are taking a backup (.cab) & restoring
the OLAP DB. After restoring when the server name is switched, the
entire setup works fine but the data source name remains the same.



So it retains the server name where it was created. This is a cosmetic
issue but one that we would like solved.



It'd be great if anyone has found a workaround to change the
datasource name.



Thanks,

Asif



mailto:asif_khan (AT) infosys (DOT) com


--
Posted via http://dbforums.com

Hi Asif,
The only way to do this is to manually change the
entry in the Analysis Services repository (usually an
access database msmdrep.mdb). If you search this access
database table OlapObjects's column ObjectDefenition, you
will find an entry for the DATASOURCE

something like this
<DATASOURCE Name="C blox qcc mdb"
ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0 ;Data
Source=C:\qcc.mdb;Persist Security Info=False;JET
OLEDB:SFP=True;"
Provider="MSDASQL"><CUSTOMPROPERTIES></CUSTOMPROPERTIES></D
ATASOURCE>

All you have to do is manually change the Name to
something else. Also do a search of all the rows for the
ObjectDefenition column for the old Datasource name and
replace it with the new name.

Cheers
Deepak