SQL Server Performance

How can i register a server in analysis service

Discussion in 'Analysis Services/Data Warehousing' started by shama, Oct 11, 2005.

  1. shama New Member

    hi all,
    Please help me with registering a new server in analysis service.whenever i try it i get the following error:

    DSO inffo:can not create temp directory c:/program files/miscrosoft analysis service/bin/.../help 80/metadata/metatemp 100/.please verify that you ve enough disk space.

    I searched the net for it and found nothing.

    I ve 1 gb of ram and 120 gb of hard drive.

    thanks & regards.
    ....Shama

    Shama

    "koi umeed nazar nahi aati, koi soorat nazar nahi aati,aati hai haal-e-dil par hansi,neend raat bhar nahi aati
  2. ghemant Moderator

    Hi,<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by shama</i><br /><br />hi all,<br />Please help me with registering a new server in analysis service.whenever i try it i get the following error:<br /><br />DSO inffo:can not create temp directory c:/program files/miscrosoft analysis service/bin/.../help 80/metadata/metatemp 100/.please verify that you ve enough disk space.<br /><br />I searched the net for it and found nothing.<br /><br />I ve 1 gb of ram and 120 gb of hard drive.<br /><br />thanks & regards.<br />....Shama<br /><br />Shama<br /><br />"koi umeed nazar nahi aati, koi soorat nazar nahi aati,aati hai haal-e-dil par hansi,neend raat bhar nahi aati<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />out of this 120 GB how much is free on your "c:" and is their any NTFS restriction on TEMP DIRECTORY (QUOTA) , @ very first look it seems that its problem of lack of space you can change the directory of installation/Temp if space is low for installation requirement as suitable.<br /><br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri Goswami<br />
  3. shama New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by ghemant</i><br /><br />Hi,<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by shama</i><br /><br />hi all,<br />Please help me with registering a new server in analysis service.whenever i try it i get the following error:<br /><br />DSO inffo:can not create temp directory c:/program files/miscrosoft analysis service/bin/.../help 80/metadata/metatemp 100/.please verify that you ve enough disk space.<br /><br />I searched the net for it and found nothing.<br /><br />I ve 1 gb of ram and 120 gb of hard drive.<br /><br />thanks & regards.<br />....Shama<br /><br />Shama<br /><br />"koi umeed nazar nahi aati, koi soorat nazar nahi aati,aati hai haal-e-dil par hansi,neend raat bhar nahi aati<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />out of this 120 GB how much is free on your "c:" and is their any NTFS restriction on TEMP DIRECTORY (QUOTA) , @ very first look it seems that its problem of lack of space you can change the directory of installation/Temp if space is low for installation requirement as suitable.<br /><br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri Goswami<br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />well whole of 120 gb is c: drive<br /><br />Shama<br /><br />"koi umeed nazar nahi aati, koi soorat nazar nahi aati,aati hai haal-e-dil par hansi,neend raat bhar nahi aati
  4. satya Moderator

  5. shama New Member

  6. ghemant Moderator

    HI,
    would you look for NTFS permission on Program Files & Winnt emp folder !

    Regards

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri Goswami
  7. satya Moderator

    That problem also happens when you are not part of the administrators' group of the machine.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  8. ranjitjain New Member

    Hi Shama,
    I guess you are registering a new server on your machine i.e. not the local one.
    So for that you need to have your userid registered in olap administrator group /administrator group on that remote machine.
    Then try registering that server in the same way you do while registering through EM for a sql server.
  9. shama New Member

    i'm registering new server on my machine for which the database server is on the remote machine.

    Shama

    "koi umeed nazar nahi aati, koi soorat nazar nahi aati,aati hai haal-e-dil par hansi,neend raat bhar nahi aati
  10. satya Moderator

    Have you checked the account privileges where it is using when registering.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  11. ranjitjain New Member

    quote:Originally posted by shama

    i'm registering new server on my machine for which the database server is on the remote machine.

    Shama

    "koi umeed nazar nahi aati, koi soorat nazar nahi aati,aati hai haal-e-dil par hansi,neend raat bhar nahi aati
    Yes then you have to set your account into olap administrator or administrator group on that remote machine.
    Because what happens is in Analysis services there is no sa only windows authentication is there.
    So when you try to register a remote server on your local one then local machine passes your windows credentials and validates in olap or admin group.
  12. shama New Member

    well people,
    Regarding the for remote database server i can understand the problem ofolap administrator group user id.But i m unable to register the local server which is on my machine.And BTW it shoud get register and started by itself when we install the analysis service tool(i mean the foodmart cubes etc).But even for registering the local sql server on my machine im getting the following error:
    "Unable to connect the registry on the server(local) or u r not a member of OLAP ADMIN group on this server"


    BTW for the remote server do i need to be in OLAP admin group on my machine or on the remote machine/server where the database resides?



    Shama

    "koi umeed nazar nahi aati, koi soorat nazar nahi aati,aati hai haal-e-dil par hansi,neend raat bhar nahi aati
  13. ranjitjain New Member

    For remote server registeration you need to be in olap group on the remote machine as your windows credentials will be verified on remote machine.
    Same way for starting on local instance you should have proper priviledges on the local setup too.
  14. blueilham New Member

    Btw I'm having the same problem too while I'm trying to register the Remote OLAP server, but I'm having different error message that the title of the window is Connection to Server Failed, and the message detail is:

    Errors occured while connecting to 10.161.xxx.xxx
    Cannot open connection to Analysis Server '10.161.xxx.xxx'.
    Cannot conect to the server '10.161.xxx.xxx'.The server is either not starteded or too busy.

    is there anything wrong or I just miss something to do?? please help me too guys..

    Ikhsan Aminuddin
    IT Consultant
    PT EBIZ CIPTA SOLUSI
    +628159895550
    +622130262272
  15. ranjitjain New Member

    quote:Originally posted by blueilham

    Btw I'm having the same problem too while I'm trying to register the Remote OLAP server, but I'm having different error message that the title of the window is Connection to Server Failed, and the message detail is:
    Errors occured while connecting to 10.161.xxx.xxx
    Cannot open connection to Analysis Server '10.161.xxx.xxx'.
    Cannot conect to the server '10.161.xxx.xxx'.The server is either not starteded or too busy.

    is there anything wrong or I just miss something to do?? please help me too guys..
    Ikhsan Aminuddin
    IT Consultant
    PT EBIZ CIPTA SOLUSI
    +628159895550
    +622130262272

    In this case you can check whether the analysis services has started on remote server or not.
    Also check for network issues if any and you can even try registering the AS server by specifying the server name
  16. satya Moderator

    Also check whether the AS service is started or not and using a proper privileged account to connect.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  17. blueilham New Member

    I have checked and started the analysis service on rempte server, but I can not register the server name,can the problem be issued in network area?? because the remote server is registered in a domain, but my PC is not registered in a domain.. please need further advice and knowledge..

    Ikhsan Aminuddin
    IT Consultant
    PT EBIZ CIPTA SOLUSI
    +628159895550
    +622130262272
  18. satya Moderator

    Ensure the domains which are used have trust between them.
    May check with your network administrator about any WINS problem that is not enabling register the server with name. Try to register with IPAddress of server.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  19. shama New Member

    quote:Originally posted by ranjitjain


    Originally posted by blueilham


    In this case you can check whether the analysis services has started on remote server or not.
    Also check for network issues if any and you can even try registering the AS server by specifying the server name
    Ranjit,
    U mean to say that Analysis Server Has to be installed on the remote server and analysis manager shud be installed on local machine or both server and manager shud be installed on the local machine?? plz clear this

    Shama

    "koi umeed nazar nahi aati, koi soorat nazar nahi aati,aati hai haal-e-dil par hansi,neend raat bhar nahi aati
  20. ranjitjain New Member

    -Shama,
    It's almost like SQL Server.
    Machine which you want to make server has to have services and like EM analysis manager is needed and like QA MDX sample application tool in needed.

    On all client machines you can install all but if you dont want services locally then you can prefer installing Only the client tool i.e. Analysis manager locally.
  21. blueilham New Member

    I've done checking if there is any issue related to the network, but unfortunately I can not figure out what is the exact matter of this problem, my friend's PC can register the server just by adding the file HOSTS with the IP and the hostname of the remote server, altought we don't register our PC in the same domain with the remote server's domain, I try to do the same, but nothing is happened.. I also have reinstalled the SQL server and the Analysis Server and added the SP4 but another windows come up when I Tried to register it again, and the title is Connection to server Failed, the detail is :
    Errors Occured while connecting to BI01.
    Cannot Open connection to Analysis server 'BI01'.
    Error in data [possible data corruption]"

    so help me guys, what should I do to solve this problem?? tnx in advance for the answer..

    Ikhsan Aminuddin
    IT Consultant
    PT EBIZ CIPTA SOLUSI
    +628159895550
    +622130262272
  22. shama New Member

    Ok,
    Thx people for ur support.It seems our server is quite restrictive ,i mean i ve been refused the user rights on it by the admins.so i came up with the idea of using my machine as a server.Btw thx to ranjit, satya et.al coz there help im able to register local server on my machine in AS.



    Shama

    "koi umeed nazar nahi aati, koi soorat nazar nahi aati,aati hai haal-e-dil par hansi,neend raat bhar nahi aati
  23. satya Moderator

    I would like to thank Ranjit's help in this regard, where his answers are more to the point than mine.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  24. ranjitjain New Member

    Thanks,<br />Satya and Shama.[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />But the thing is i have learned alot from SSP and especially you Satya.[<img src='/community/emoticons/emotion-2.gif' alt=':D' />][<img src='/community/emoticons/emotion-2.gif' alt=':D' />][<img src='/community/emoticons/emotion-1.gif' alt=':)' />][<img src='/community/emoticons/emotion-1.gif' alt=':)' />][<img src='/community/emoticons/emotion-1.gif' alt=':)' />][^]

Share This Page