The notes I have are that the SQL must be SP1 CU2 (or higher). From: http://technet.microsoft.com/en-us/library/ee721049.aspx#prereqs
"You must have a full installation of Microsoft SQL Server, not the Express edition. If you are using SQL Server 2008, you must have Service Pack 1 (SP1) and Cumulative Update 2 (CU2) " On 24 August 2012 12:55, 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