SQL Server Performance

Error user does not have permission

Discussion in 'SQL Server 2005 Analysis Services' started by dineshasanka, Oct 10, 2006.

  1. dineshasanka Moderator

    I am getting folloing error when I start to deploy.

    Either the 'DomainUserName' user does not have permission to create a new object in 'ServerName', or the object does not exist.
    (Microsoft.AnalysisServices)

    This user is in the dbcreator role



    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
    dineshasanka, Oct 10, 2006
    #2

  2. ranjitjain New Member

    Hi Dinesh,
    Analysis services validates the windows account i.e. your windows credentials will be checked.
    So the windows account which you are using has to be into administrator group.

    Otherr alternative is to set the Analysis service to run as a specific windows account and not local system account
    ranjitjain, Oct 10, 2006
    #2

  3. dineshasanka Moderator

    Well , I have a windows account but that user has a role of dbcreator. I will try your option and let you know

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
    dineshasanka, Oct 10, 2006
    #2

  4. dineshasanka Moderator

    It works thanks

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
    dineshasanka, Oct 11, 2006
    #2

  5. ranjitjain New Member

    Hi Dinesh,
    can you please share which option worked for you?
    ranjitjain, Oct 11, 2006
    #2

  6. dineshasanka Moderator

    I put my account to admin group.
    Also, there is a option in SSAS to add the user to Analysis service. After that it was ok. you don't have to put this user to admin group

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
    dineshasanka, Oct 11, 2006
    #2

Share This Page