Friday, 20 January 2012

Rename an Analysis Services Instance

This is just a short post for Friday. I have been working a fair amount with SSAS and the rest of the BI stack and recently  I was asked to install a default instance of SSAS on server that already had a named instance installed. I didn’t think this would take me a long time I had a quick look at Configuration Manager saw the named SSAS instance mounted up the ISO and off I went.

Click click click click done. Oh an Error…”The instance ID needs to be unique please ”  on further investigation it seemed that the existing named instance had the default instance ID. How could that be I thought?

It turns out that the current named instance was initially installed as the default instance then got renamed. SSAS instances are far more easily renamed than  Database Engine instances. The recommended way to change a database engine default instance to a named instance is to uninstall and re-install the server. Fortunately with SSAS the process is much more straight forward.

SSAS actually ships with an instance rename tool, this article on the Microsoft  site talks you through how to use it

My rename tool can be found her

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE

The tool is called ASInstanceRename.exe

Fire it up and you get a screen that looks like this


Select an instance to rename from the drop-down list and specify the new name for the instance. In this case I’m renaming my default instance and making it a named instance imaginatively called NewInstance. You click on OK and the instance gets renamed and I get a named instance of SSAS

Now I’d have to connect to the SSAS instance using ServerName\InstanceName

If you want to make a named instance the default instance, then you leave the new instance name field  blank. This process will fail if you already have a default instance.

No comments:

Post a Comment

Featured post

OUT OF SUPPORT: SQL Server 2008 and SQL Server 2008 R2

Welcome to this post, on SQL Server 2008 and 2008 R2, both of these versions of SQL server will go out of  extended support with Microsoft t...