SSIS Installation - "Failure setting security rights on user account SQLServer2005DTSUser$ComputerName"

  • Hi,

    I was able to install SQL Server 2005 Developer Edition on XP Professional SP2 OS. Later, I tried installing SSIS a few times. Below is the same failure message (copied from the Bootstrap log files) each time i install :

    +++++++++++++++++++++++++++++++++++++++++++++

    MSI (s) (C8:D4) [18:21:16:343]: Executing op: CustomActionSchedule(Action=Do_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlUserSecurity,CustomActionData=010Setting User Security50000SQLServer2005DTSUser$SAHARASeServiceLogonRightSQLServer2005DTSUser$SAHARASeChangeNotifyPrivilegeSQLServer2005DTSUser$SAHARASeCreateGlobalPrivilegeSQLServer2005DTSUser$SAHARASeImpersonatePrivilege)

    MSI (s) (C8:90) [18:21:16:359]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSICB.tmp, Entrypoint: Do_sqlUserSecurity

    <Func Name='LaunchFunction'>

    Function=Do_sqlUserSecurity

    <Func Name='GetCAContext'>

    <EndFunc Name='GetCAContext' Return='T' GetLastError='203'>

    Doing Action: Do_sqlUserSecurity

    PerfTime Start: Do_sqlUserSecurity : Sun Jun 27 18:21:16 2010

    <Func Name='Do_sqlUserSecurity'>

    Failure setting security rights on user account SQLServer2005DTSUser$SAHARA

    Error Code: 0x80077341 (29505)

    Windows Error Text: Source File Name: sqlca\sqlsecurityca.cpp

    Compiler Timestamp: Thu Sep 1 22:23:05 2005

    Function Name: Do_sqlUserSecurity

    Source Line Number: 115

    +++++++++++++++++++++++++++++++++++++++++++++

    Please help..

    Thanks,

    Amit

  • IS the user account being used to install this an admin type account in XP?

    You might look at this:

    http://social.msdn.microsoft.com/Forums/en-US/sqlnotificationservices/thread/7d349834-46dc-476f-9ba0-4c7690b6e01a

    CEWII

  • Installer user is a Admin User. Same user account was used to Installed SQL Server 2005.

Viewing 3 posts - 1 through 2 (of 2 total)

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