SQL Server Performance

Analysis Services roles disappearing

Discussion in 'SQL Server 2005 Analysis Services' started by Bendaberg, Nov 26, 2007.

  1. Bendaberg New Member

    In a production environment, I have defined a single role to allocate access to 4 cubes.
    On 2 occasions, this role has simply disappeared, and all access is lost.
    I can see nothing in Event Viewer to explain. I've seen no hotfixes in relation to the issue.
    SQL Server is version 3052, on Windows 2003 Server Standard Edition SP2
    Any more info will be provided if required,
    Help appreciated!!

  2. Bendaberg New Member

    Issue found....
    The BI solution files did not contain the Role & its membership, and deployment was dropping the AS database, and recreating it without the role.

Share This Page