Create and alias to a (named) instance of Analysis Services 2005/8 - by Tiago Rente - VF-PT

Status : 


Sign in
to vote
ID 432644 Comments
Status Active Workarounds
Type Suggestion Repros 3
Opened 4/15/2009 6:54:01 AM
Access Restriction Public


It is possible to create alias to SQL Server (Database Engine) using "SQL Server Configuration Manager".

It must be possible to create an alias to a instance of Analysis Services 2005/8, regardless the instance is or is not a named instance.
E.g., <AS alias name> = <server name> or <AS alias name> = <server name>\<instance name>
Sign in to post a comment.
Posted by HAL9256 on 1/2/2014 at 12:03 PM
A workaround I found for using an Alias for just connecting to the default instance is is to disable the loopback check. This won't help with the named instances, but could help with a single named instance.

Execute the following Registry fix:

Windows Registry Editor Version 5.00

Posted by mvoltchenko on 6/18/2012 at 8:43 AM
Has there been a resolution to this issue? I am trying to create an alias to access Analysis Services in SQL 2012 and still getting the same error "No such host is know"
Posted by Shriniwas on 5/24/2010 at 8:09 AM
Is this issue resolved in SQL Server 2008? Is it possible to create Alias for Analysis server instance in 2008
Posted by Kathy [MSFT] on 1/5/2010 at 6:56 PM
We are continuing to investigate this issue and will consider making a change in a future release of SQL Server.

The Analysis Services Team
Posted by Microsoft on 7/28/2009 at 4:21 PM
Thanks a lot renteta for your suggestion.
We will take a look at this for the future version of Analysis Services.
The Analysis Services Team.