SQL Server Performance

copy security groups ! urgent

Discussion in 'SQL Server 2005 Analysis Services' started by yukon_dba, Sep 20, 2007.

  1. yukon_dba New Member

    I need to copy the security groups from production to stage ,as users are not able to access the cube online...
    ( note :the production server is analysis sercvices 2000 and the stage server is analysis services 2005)
    any ideas ? thanks in advance
    yukon dba
  2. Adriaan New Member

    In SQL 2000, I would use the script generation wizard twice.
    For the first script you select the Script All Objects option, then deselect all Formatting Options, and select those Security Scripting Options that you need.
    For the second script, you do not select any object at all, then for formatting you select the CREATE command only, and for the Security Scripting Options you select the ones that you need.
    You need to run the second script before the first one. Test this on a copy of the production database, before implementing.
  3. satya Moderator

    Please post your question in relevant forum section only.
    With the updated books online for SQL 2005 there is a section "Securing Analysis Services " that explains the information:
    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uas9/html/1867eaa6-65b2-4969-b2d9-d49b386850c7.htm

Share This Page