I believe the patch levels apply to R2 as well: http://www.sqlsecurity.com/faqs-1/sql-server-versions/2008-r2
On 24 August 2012 13:28, Nigel Hertz <nigel.he...@stockland.com.au> wrote: > That’s for SQL 2008, Marko is on SQL 2008 R2 I think.**** > > ** ** > > *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On > Behalf Of *Chris Howell > *Sent:* Friday, 24 August 2012 1:27 PM > > *To:* ozMOSS > *Subject:* Re: User Profile Service**** > > ** ** > > 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**** > > ** ** > > ------------------------------ > Stockland Notice: If this communication has been sent to you by mistake, > please delete and notify us. If it has been sent to you by mistake, legal > privilege is not waived or lost and you are not entitled to use it in any > way. Stockland and its subsidiaries reserve the right to monitor e-mail > communication through its networks. > > _______________________________________________ > 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
