Hey Marko, The approach I take with setting this up in new non-prod environments is to:
Backup and restore the *ProfileDB* from production into the SQL Server of the new environment, and also the *SocialDB*. DO NOT restore the *SyncDB* Use the following powershell to provision the service application: New-SPServiceApplicationPool –Name "User Profile Service Application Pool" –Account "DOMAIN\UPSAACCOUNT" $upa= New-SPProfileServiceApplication –Name "User Profile Service Application" –ApplicationPool "User Profile Service Application Pool" –ProfileDBName "RESTORED_ProfileDB" –SocialDBName "RESTORED_SocialDB" –ProfileSyncDBName "DOESNT_EXIST_YET_SyncDB" New-SPProfileServiceApplicationProxy –ServiceApplication $upa –Name "User Profile Service Application Proxy" –DefaultProxyGroup Note the above command will create a fresh new SyncDB and reuse your restored ProfileDB and SocialDB. When completed, go in to the user profile service application and manually recreate your synchronisation connection etc. and run a full sync. The benefit of this approach is after you're done you should have your user profile data from production restored into your new environment :) I also restore the My Site content db from prod as as a seperate step as well. If your having dramas creating this, the above probably won't fix any of your issues :( Regards, Sezai Komur SharePoint Solutions Architect | SharePoint Server MVP NEC IT Solutions On Fri, Aug 24, 2012 at 10:55 AM, Marko Salonen < marko.salo...@moretonbay.qld.gov.au> wrote: > 10.50.1600.1 so SQL 2008 R2 with no patches**** > > ** ** > > Regards,**** > > ** ** > > Marko**** > > ** ** > > -- **** > > Marko Salonen > Senior Applications Analyst**** > > Moreton Bay Regional Council > 220 Gympie Road, Strathpine Q 4500 > P 07 3480 6531**** > > F 07 5433 2188**** > > www.moretonbay.qld.gov.au**** > > ** ** > > *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On > Behalf Of *Chris Howell > *Sent:* Friday, 24 August 2012 12:48 PM > *To:* ozMOSS > *Subject:* Re: User Profile Service**** > > ** ** > > Hi Marco,**** > > ** ** > > What is your patch level on the SQL server?**** > > ** ** > > From my experience with UPS, all my issues were fixed by a SQL patch.**** > > ** ** > > Chris**** > > On 24 August 2012 12:20, Marko Salonen < > marko.salo...@moretonbay.qld.gov.au> wrote:**** > > Hi All**** > > **** > > Wow, what a week. I have been banging my head against a brick wall with > this one, and I feel defeated. Not a great introduction to SharePoint for > my colleagues, and I amazed that this is so difficult. To make myself feel > a little better I just remember that the leader of Kony 2012 got arrested > before Kony did! J**** > > **** > > Today I started from a completely clean environment. Recreated my service > accounts, and went over the accounts in > http://www.harbar.net/articles/sp2010ups.aspx step by step with our > networking guys, and followed the instructions to the letter. Alas to no > avail. **** > > **** > > When others have followed the instructions by Harbar, have you started any > other services? If yes, which ones?**** > > **** > > To recap**** > > **** > > Win 2008 R2**** > > SharePoint 2010 SP1 July 2012 CU**** > > **** > > SQL 2008 R2**** > > **** > > I open the 1433 port**** > > I create an SQL Alias**** > > I set local admin access**** > > I set local login**** > > **** > > Run Config Wizard (not using the AutoSPInstall)**** > > **** > > I then follow the Harbar instructions to create the UPS.**** > > **** > > Regards,**** > > **** > > Marko**** > > **** > > -- **** > > Marko Salonen > Senior Applications Analyst**** > > Moreton Bay Regional Council > 220 Gympie Road, Strathpine Q 4500 > P 07 3480 6531**** > > F 07 5433 2188**** > > www.moretonbay.qld.gov.au**** > > **** > > MORETON BAY REGIONAL COUNCIL (MBRC) PRIVILEGED PRIVATE AND CONFIDENTIAL - > The information contained in this e-mail and any attachments is > confidential and may attract legal privilege. It is only intended for the > named recipient/s. If you are not a named recipient any use of this > information including copying, distribution and publication is prohibited. > Confidentiality and legal privilege are not waived or lost as a result of > mistaken or erroneous delivery. If you are not a named recipient, please > delete all copies immediately and contact the sender to advise of the error. > **** > > It is recommended that you scan this email and any attachment before > opening. MBRC does not accept any responsibility or liability for loss or > damage arising directly or indirectly from opening this email, opening any > attachments or any communication errors.**** > > The views expressed in this email and any attachments are the personal > views of the sender unless otherwise stated.**** > > > _______________________________________________ > ozmoss mailing list > ozmoss@ozmoss.com > http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss**** > > ** ** > > _______________________________________________ > ozmoss mailing list > ozmoss@ozmoss.com > http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss > >
_______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss