SQL 2000 Analysis Services from SQL 2005 Management Studio

  • is it possible to log into SQL 2000 Analysis Services from SQL 2005 Management Studio? I tried but no luck.

  • I am pretty sure this is not supported. 

    ---------------------------------------
    elsasoft.org

  • Don't know about 2000.

    Here's instructions for 2005:

    http://www.sqlservercentral.com/columnists/jSebastian/2865.asp

    Hope it helps

  • if you have AS 2005, all that is not necessary if the server is visible on the network.  Just type the AS instance name (either a default or named instance) into the connection dlg and you can connect.

    I would say it's not recommended to expose an AS box to the web, as the article seems to recommend.  SQL Server should not be exposed to the web either.  That is unless you want to present a nice fat attack surface to criminals who would like to steal your data...

    ---------------------------------------
    elsasoft.org

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

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