Sharepoint 2010 Installation - User Profile Synchronization creation failing RRS feed

  • Question

  • I am trying to install SharePoint 2010 using AutoSPInstaller but its failing to even create user profile service application. I am using SPT_Admin to run the script on App server and the account has dbcreator and securityadmin access in database and administrator on the SharePoint box. I have applied SP2 and we are using SQL server 2012. Please let me know if anyone encountered this issue before and any tips for troubleshooting.

    Creating User Profile Service Application as domain\SPP_Farm...
    New-SPProfileServiceApplication : The EXECUTE permission was denied on the obje
    ct 'sp_send_dbmail', database 'msdb', schema 'dbo'.
    At C:\Users\spt_admin\AppData\Local\Temp\AutoSPInstaller-ScriptBlock.ps1:3 c
    + $newProfileServiceApp = New-SPProfileServiceApplication <<<<  -Name "User Pro
    file Service Application" -ApplicationPool "SharePoint Hosted Services" -Profil
    eDBServer Daa301SPTA1-ProfileDBName SPT_UserProfile -ProfileSyncDBServer Daa301SPTA1 -ProfileSyncDBName SPT_UserProfile_Sync -SocialDBServer Daa301SPTA1 -
    SocialDBName SPT_UserProfile_Social -MySiteHostLocation http://mysites.contoso
    .com:5050 -MySiteManagedPath "personal"
        + CategoryInfo          : InvalidData: (Microsoft.Offic...viceApplication:
       SPCmdletNewProfileServiceApplication) [New-SPProfileServiceApplication], S
        + FullyQualifiedErrorId : Microsoft.Office.Server.UserProfiles.PowerShell.

    C:\Users\spt_admin\AppData\Local\Temp\AutoSPInstaller-ScriptBlock.ps1 :  - F
    ailed to create User Profile Service Application
    At line:1 char:73
    + C:\Users\spt_admin\AppData\Local\Temp\AutoSPInstaller-ScriptBlock.ps1 <<<<

        + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorExcep
        + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorExceptio

    • Edited by ViviSP Wednesday, April 26, 2017 4:57 PM
    Wednesday, April 26, 2017 4:56 PM