Post reply

Cannot Register Analysis Server - SQL Server 64 bit

  • February 7, 2006 at 2:48 am

    #116137

    I re-installed a Microsoft SQL Server 2000 (64 bit version) containing database and OLAP cubes. The Windows 2003 Server (64 bit) was re-installed and all hard drives was formatted.

    Since MSSQL 64-bit doesn't have user interface (like Enterprise Manager and Analysis Manager), I used the Enterprise Manager on a laptop, and then added the 64-bit Database Server and Analysis Server to the said Enterprise Manager.

    Well, I have successfully registered the 64-bit MSSQL Database Server; it already appeared on my Enterprise Manager and I can browse its contents. However, when I add the Analysis Service to the Analysis Manager, it failed with the following error message:

    Errors occured while connecting to 192.200.100.238.

    Cannot open connection to Analysis server'192.200.100.238'.

    Error in data [Possible data corruption] "

    Do you still want to register this server?

    http://i3.photobucket.com/albums/y71/kreshna_iceheart/IT%20Problems/00-OLAP_Error.jpg

    Well, I think it was weird, because I have successfully registered the Database Server with exactly the same IP address. Furthermore, I don't think there could be any possible data corruption, because I haven't created anything on the SQL Server.

    Also, when I tried to register the Analysis Server anyway, it appeared on the Analysis Manager console, but marked with red (instead of green). Furthermore, when I tried to browsed it, it gives the error message "Automation Error".

    What's going on? Thanks!

  • February 10, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • June 20, 2007 at 6:57 am

    #714077

    I have the same error...

    Did you ever get the solution???

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

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