Monday, March 19, 2012

Issues Renaming Analysis Server Instance

Hi Friends

I want to rename My Analysis Services Instance installed on E: Drive. I read an article how to rename the Analysis Service Instance . Then I followed 64-bit path to rename, but it gives the following error rolling back to the original Instance Name:

Registering the new performance counters file:

LoadPerfCounterTextStrings for file C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\bin\msmdctr.ini failed with error code 2

The System cannot find the file Specified

Has anybody came across this issue. Any workarounds ?

Thanks

Subhash Subramanyam.

Hi Subash,

I need few more info from you before I troubleshoot the issue.

1) What was the intial folder your Analysis Service resides? ex: E:\program files\mssql.1\olap\bin

2) What was the original instance name and what did you rename to?

3) Do you get this error from asinstancerename tool?

Thanks,

Deva

|||

1) What was the intial folder your Analysis Service resides? ex: E:\program files\mssql.1\olap\bin

C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\bin

2) What was the original instance name and what did you rename to?

original instance name: ss2005

rename to: as2005

3) Do you get this error from asinstancerename tool?

Yes

Hope this helps.

Thanks

Subhash Subramanyam

No comments:

Post a Comment