Post reply

Analysis Services Error: Urgent Help

  • December 1, 2003 at 12:11 am

    #160459

    Hi All,

    I am using Win XP Pro (SP1), SQL Server 2000 Developer (SP3). After installing SP3 when i try to connect to Analysis Services i get an error. "Unable to connect to the registry of the Server <Server Name>". I am dministrator of the system and i dont have any permissions issues. I have tried to reinstall the SQL server but no luck and now i am stuck.

    Waiting for urgent reply.

    Thanks in advance.

    Kind Regards,

    Affan

  • December 4, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • December 4, 2003 at 9:25 am

    #484650

    If you have Analysis Services running on a server and are trying to connect from your desktop, you will get the error you described if you did not install the same Service Pack for Analysis Services on your desktop that you installed on the server.

  • December 4, 2003 at 10:09 pm

    #484746

    But i amd trying ot connect it to the enterprise manager of Analysis services and i ma using a single machine and it used to work in case of win2k professional.

  • December 4, 2003 at 10:41 pm

    #484747

    You may want to review and try the things suggested here... http://www.dbforums.com/t880646.html

    Also, make sure you have loaded (maybe even reload) SP3 (this was a known issue pre-SP1 http://support.microsoft.com/?id=307365

    HTH,

    Steve.

    Steve.

  • December 5, 2003 at 12:22 am

    #484751

    Add on to the problem i want ot ask one question, is there any difference between SQL Service Packs and Analysis Server Service Packs. coz i have found in some articles that apply Analysis Services SP1 or later. Does SQL server 2000 SP3a contains fixes for Analysis Services or is there sperate Service Packs which we need to apply. My understanding is that SP3a should conatain fixes for all relevant SQL Server 2000 Products.

    Regards,

    Affan

  • December 5, 2003 at 9:11 am

    #484860

    When you get an SP for SQL Server it includes seperated SPs for the database and for Analysis Services.

  • December 7, 2003 at 5:30 am

    #485014

    Crucker1 is right. If you got your SP on CD, look for the msolap folder, it will contain the Analysis Services service pack (for the server, and the sub-folder of DTS is for your client machines).

    If you downloaded it from MSft, you definitely need to download a separate service pack exe for AS and for the relation engine.

    HTH,

    Steve.

    Steve.

  • December 7, 2003 at 10:16 pm

    #485033

    Thanks every body,

    Yes, when i installed SP from CD it had a spereate folder and i installed it and now its working fine, every problem is solved. and downloaded SP does not contain the analysis services SP.

    Thanks again,

    Regards,

    Affam

Viewing 9 posts - 1 through 8 (of 8 total)

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