none
Sharepoint 2010 upgrade to 2013...user profile sync

    Question

  • I am upgrading from SharePoint 2010 ent to 2013 ent. Everything seemed to be fine until I upgraded the Sharepoint farm to March PU.

    I had some errors after running the March 2013 patch which I corrected. After correcting the errors, I started user profile sync with no errors and synced all users. 
    then around 1:00 in the night I can see that there is a generic error and the user profile sync stopped.
    After some time me and a friend of mine fixed the error. The sync was started and synced.

    Because this Farm is not yet used by any users and still in progress, I deleted the main web application which also has mysite in it. 

    created a new web application and upgraded a backup of the 2010 content database to claims on the 2013 farm and also upgraded to 15 hive (all SCs)
    Then I tried to stop / start user profile sync in system services and I get this error "Failed to configure MIIS post database"

    I have many times installed SharePoint with user profile and I know the permissions of the service accounts are correct.
    The difference though is, that in the 2010 environment I have different service users than in the 2013 environment.

    Is it possible that I need to format the server and start over again? or can it be that I need to use the old service users also for the 2013 setup?

    best regards,
    Olafur

    this is a guideline I follow to upgrade the content dbs. 

    1.) 
    delete backups from the 2010 sql server

    2.)
    backup of source DBs and put it to F drive.
    BACKUP DATABASE [MYSITE] TO  DISK = N'F:\backup\mysite.bak' WITH  COPY_ONLY, NOFORMAT, NOINIT,  NAME = N'MYSITE-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
    GO
    BACKUP DATABASE [WEBSite] TO  DISK = N'F:\backup\WEBSite.bak' WITH  COPY_ONLY, NOFORMAT, NOINIT,  NAME = N'WEBSite-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
    GO

    3.) 
    STOP USER PROFILE OG USER PROFILE SYNC

    4.) 
    copy .bak files to the new 2012 sql server

    5.)
    Create new web application with new temporary content DBs
    Classic authentication
    $DBServer = "sql2013"
    $hosthttps = "https://"
    $hostgroup = ".dom.is"
    $applicationpool = "SharePoint - WebApp"
    $ap = "NTLM"


    $hostslod = "innri"
    $DBName = "sp2013_henda3_" + $hostslod
    $host1 = $hosthttps + $hostslod + $hostgroup
    $hostH = $hostslod + $hostgroup
    $WebAppName = "Sharepoint - " + $hostslod
    New-SPWebApplication -Name $WebAppName -ApplicationPool $applicationpool  -URL $host1 -Port 443 –AuthenticationMethod $ap -SecureSocketsLayer -AllowAnonymousAccess -DatabaseName $DBName -DatabaseServer $DBServer -HostHeader $hostH

    Remove-SPContentDatabase -identity $DBName -confirm:$false -force

    6.)
    Restore databases to the new SQL2012 
    RESTORE CONTENT DBS
    USE [master]
    RESTORE DATABASE [SP2013_CONTENT_WEBSite] FROM  DISK = N'D:\Backup\WEBSite.bak' WITH  FILE = 1,  MOVE N'WEBSite' TO N'D:\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\SP2013_CONTENT_WEBSite.mdf',  MOVE N'WEBSite_log' TO N'l:\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\SP2013_CONTENT_WEBSite_log.LDF',  NOUNLOAD,  STATS = 5
    RESTORE DATABASE [SP2013_CONTENT_MYSITE] FROM  DISK = N'D:\Backup\mysite.bak' WITH  FILE = 1,  MOVE N'MYSITE' TO N'D:\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\SP2013_CONTENT_MYSITE.mdf',  MOVE N'MYSITE_log' TO N'l:\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\SP2013_CONTENT_MYSITE_log.LDF',  NOUNLOAD,  STATS = 5
    GO

    USE [SP2013_CONTENT_WEBSite]
    GO
    CREATE USER [dom\sp.setup] FOR LOGIN [dom\sp.setup]
    GO
    USE [SP2013_CONTENT_WEBSite]
    GO
    ALTER ROLE [db_owner] ADD MEMBER [dom\sp.setup]
    GO
    USE [SP2013_CONTENT_WEBSite]
    GO
    ALTER ROLE [SharePoint_Shell_Access] ADD MEMBER [dom\sp.setup]
    GO
    USE [SP2013_CONTENT_MYSITE]
    GO
    CREATE USER [dom\sp.setup] FOR LOGIN [dom\sp.setup]
    GO
    USE [SP2013_CONTENT_MYSITE]
    GO
    ALTER ROLE [db_owner] ADD MEMBER [dom\sp.setup]
    GO
    USE [SP2013_CONTENT_MYSITE]
    GO
    ALTER ROLE [SharePoint_Shell_Access] ADD MEMBER [dom\sp.setup]
    GO
    USE [SP2013_CONTENT_WEBSite]
    GO
    CREATE USER [dom\domvmiweb~svc] FOR LOGIN [dom\domvmiweb~svc]
    GO
    USE [SP2013_CONTENT_WEBSite]
    GO
    ALTER ROLE [db_owner] ADD MEMBER [dom\domvmiweb~svc]
    GO
    USE [SP2013_CONTENT_WEBSite]
    GO

    7.)
    $slod = "https://WEBSite.dom.is/"
    New-SPManagedPath "my/personal" -WebApplication $slod
    New-SPManagedPath "leit" -WebApplication $slod -explicit
    New-SPManagedPath "my" -WebApplication $slod -explicit
    Mount-SPContentDatabase "SP2013_CONTENT_WEBSite" -DatabaseServer "SQL2013" -WebApplication https://WEBSite.dom.is
    Mount-SPContentDatabase "SP2013_CONTENT_MYSITE" -DatabaseServer "SQL2013" -WebApplication https://WEBSite.dom.is

    Convert-SPWebApplication -Identity "https://WEBSite.dom.is" -To Claims –RetainPermissions -Force
    xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
    xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
    xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
    Upgrade-SPSite https://WEBSite.dom.is –VersionUpgrade
    Upgrade-SPSite https://WEBSite.dom.is/leit –VersionUpgrade
    Upgrade-SPSite https://WEBSite.dom.is/my –VersionUpgrade
    Upgrade-SPSite https://WEBSite.dom.is/my/personal/asgeir –VersionUpgrade
    Upgrade-SPSite https://WEBSite.dom.is/my/personal/bergur –VersionUpgrade
    Upgrade-SPSite https://WEBSite.dom.is/my/personal/e_gylfadottir –VersionUpgrade
    Upgrade-SPSite https://WEBSite.dom.is/my/personal/gudjonth –VersionUpgrade
    Upgrade-SPSite https://WEBSite.dom.is/my/personal/heimir –VersionUpgrade
    Upgrade-SPSite https://WEBSite.dom.is/my/personal/lgudmund –VersionUpgrade
    Upgrade-SPSite https://WEBSite.dom.is/my/personal/ragnvig –VersionUpgrade
    Upgrade-SPSite https://WEBSite.dom.is/my/personal/svanhildur –VersionUpgrade
    Upgrade-SPSite https://WEBSite.dom.is/my/personal/v_halldorsson –VersionUpgrade
    Upgrade-SPSite https://WEBSite.dom.is/sites/FAQ –VersionUpgrade
    Upgrade-SPSite https://WEBSite.dom.is/sites/Upplysingasvid –VersionUpgrade

    take care of super user and reader.

    8.)
    ALTER ROLE [SPDataAccess] ADD MEMBER [dom\domvmiweb~svc]
    GO
    USE [SP2013_CONTENT_MYSITE]
    GO
    CREATE USER [dom\domvmiweb~svc] FOR LOGIN [dom\domvmiweb~svc]
    GO
    USE [SP2013_CONTENT_MYSITE]
    GO
    ALTER ROLE [db_owner] ADD MEMBER [dom\domvmiweb~svc]
    GO
    USE [SP2013_CONTENT_MYSITE]
    GO
    ALTER ROLE [SPDataAccess] ADD MEMBER [dom\domvmiweb~svc]
    GO
    USE [SP2013_CONTENT_WEBSite]
    GO
    ALTER ROLE [SPDataAccess] ADD MEMBER [dom\domvmiweb~farm]
    GO
    USE [SP2013_Config_Admin]
    GO
    ALTER ROLE [db_owner] ADD MEMBER [dom\gagnalestur]
    GO
    USE [SP2013_Config_Admin]
    GO
    ALTER ROLE [SPDataAccess] ADD MEMBER [dom\gagnalestur]
    GO
    USE [SP2013_Config_Admin]
    GO
    ALTER ROLE [WSS_Content_Application_Pools] ADD MEMBER [dom\gagnalestur]
    GO
    USE [SP2013_CONTENT_WEBSite]
    GO
    ALTER ROLE [SPDataAccess] ADD MEMBER [dom\gagnalestur]
    GO
    USE [SP2013_CONTENT_MYSITE]
    GO
    CREATE USER [dom\gagnalestur] FOR LOGIN [dom\gagnalestur]
    GO
    USE [SP2013_CONTENT_MYSITE]
    GO
    ALTER ROLE [db_owner] ADD MEMBER [dom\gagnalestur]
    GO
    USE [SP2013_CONTENT_MYSITE]
    GO
    ALTER ROLE [SPDataAccess] ADD MEMBER [dom\gagnalestur]
    GO
    USE [SP2013_CONTENT_MYSITE]
    GO
    ALTER ROLE [db_owner] ADD MEMBER [dom\domvmiweb~svc]
    GO
    USE [SP2013_CONTENT_MYSITE]
    GO
    ALTER ROLE [SharePoint_Shell_Access] ADD MEMBER [dom\domvmiweb~svc]
    GO
    USE [SP2013_CONTENT_MYSITE]
    GO
    ALTER ROLE [SPDataAccess] ADD MEMBER [dom\domvmiweb~svc]
    GO

    USE [SP2013_CONTENT_WEBSite]
    GO
    ALTER ROLE [db_owner] ADD MEMBER [dom\domvmiweb~svc]
    GO
    USE [SP2013_CONTENT_WEBSite]
    GO
    ALTER ROLE [SharePoint_Shell_Access] ADD MEMBER [dom\domvmiweb~svc]
    GO

    9.)


    10.)
    deploy solutions

    10.) 
    NINTEX STARTA
    activate á web apps for nintex

    11.)
    starta user profile
    test sync á user profile (this fails)

    Sunday, November 10, 2013 11:10 PM

Answers

All replies