SQL Server Performance

Analysis services account

Discussion in 'Analysis Services/Data Warehousing' started by snarayanas, Sep 19, 2006.

  1. snarayanas New Member

    Hi ,

    For installation of Analysis services whether domain account/ local system account can be used for start the services.

  2. ghemant Moderator

    AFAIK you can run the setup if your domain user have sufficient privilage on your system, and to start analysis service configure Analysis Service Account with LOCAL SYSTEM /USER ACCOUNT (DOMAIN/LOCAL) with sufficient privilage. refer *Service Account* and *Setting Up Windows service Account* in BOL for more.

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

    If you have many DTS packages to be used for data imports and exports on a network share then I would suggest to use a domain account with necessary privileges.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page