SQL Server Performance

Automation Error

Discussion in 'Analysis Services/Data Warehousing' started by beaniebear, Feb 28, 2007.

  1. beaniebear New Member

    I got "automation error, the specified procedure could not found" when accessing to analysis server. Is anybody have any idea about this error?

    Thanks
    Kathy
  2. ranjitjain New Member

    Error could come when you access analysis server through analysis server manager and the service is not running or not responding.
    Make sure that AS service is running and then you are connecting to it.
  3. satya Moderator

    This might happen due to the .DLLs issue on that server, so check event viewer logs as well for any binaries problem.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  4. tboonleong Member

    I also facing same error with this error msg.

    Initiating transaction in Database
    Automation error Library not registered

    I had checked the services and confirmed service was well running.
    Anybody have any idea regarding this error?
    Thanks


  5. satya Moderator

    See this kBAhttp://support.microsoft.com/kb/885426 for those messges.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  6. tboonleong Member

    I had check the services and confirm it is runnig.<br />After that i reinstall the services pack then issue solve and no error when reprocess cube.<br /><br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]Thanks everyone for your help.

Share This Page