Post reply

Error : Aspnet_ChangeNotification_ReceiveNotificationsOnlyAccess

  • August 2, 2011 at 3:04 am

    #142818

    Hi..

    I have one ssis package 2008 in that i transferring the tables and sp's using Transfer sql server object task..

    when i execute the package

    i'm getting this error ..

    "[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "ERROR : errorCode=0 description=Cannot find the user 'aspnet_ChangeNotification_ReceiveNotificationsOnlyAccess', because it does not exist or you do not have permission. helpFile= helpContext=0 idofInterfaceWithError={C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}"."

    Help me ...

  • August 2, 2011 at 4:06 am

    #1362023

    Maybe you have permission problems?

    Are you running the package manually or on the server?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • August 7, 2011 at 11:50 pm

    #1365023

    hi

    thanks for reply ..

    i'm using manual ...

    but how to assign permission ..

    i'm getting the same error

    help me ..

  • August 8, 2011 at 2:53 am

    #1365062

    From BOL:

    The user must have permission to browse objects on the source server, and must have permission to drop and create objects on the destination server; moreover, the user must have access to the specified database and database objects.

    http://msdn.microsoft.com/en-us/library/ms142159.aspx

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • August 8, 2011 at 5:00 am

    #1365090

    Thanks ... i got it

    i just created the user by that name and problem solved .. 🙂 🙂

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply