Analysis Services on Multi Instance

  • I am considering moving Analysis Services to a multi instance platform. Does anyone know of any potential issues?

    Thanks in advance

  • This was removed by the editor as SPAM

  • I assume you mean multiple instances of SQL server on the same system?

    If this is the case, there should be no issues just make sure you use the full and correct name of the system and data source.

  • Analysis Services, while having the SQL Server name, is really a separate product. Keep in mind that the supporting database is in MS Access, though you can switch it to SQL Server.

    Analysis Services, in and of itself, doesn't have multiple instances like SQL Server core does. You can install it on systems regardless of how many instances of SQL Server core are present (to include none).

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

  • Thanks for the replies.

    I am looking at migrating a whole system to a datacenter. The system includes AS, and I just wondered if there were going to be any gotchas.

    If I find any, I'll let you all know!!!

    R

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply