none
ADFS2.0 Step-by-Step setup lab environment

    Question

  • I am setting my ADFS2.0 lab from the ms tech net site using the "How to setup a ADFS2.0 Lab Enviornment". In step #5 in installing sql 2008sp1 and then running the "HOL_Doctors_db.sql" which says that you can find this script by clicking on File-Open-selecting the file where the script was saved. The problem is that I can not find this script. I am using sql2008R2. I am stuck and could really use assistance.

    Thank You

    Friday, February 10, 2012 9:35 PM

Answers

All replies

  • Hi,

    Did you download the support files?

    Did you download prerequisite software from step 2?

    SQL script (HOL_Doctors_DB.sql) is included with the support files.

    Go through this: http://technet.microsoft.com/en-us/library/adfs2-how-to-setup-lab-environment-for-federated-collaboration-02(WS.10).aspx

    Download from here:http://connect.microsoft.com/site642/Downloads/DownloadDetails.aspx?DownloadID=25391


    Best Regards,

    Abhijit Waikar.
    MCSA 2003|MCSA:Messaging| MCTS|MCITP:Server Administrator|Microsoft Community Contributor | My Blog

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.


    Friday, February 10, 2012 9:44 PM
  • Abhijit,

    Yes, I did download all the prerequisites software from step 2. Everything else is all set up from the previous steps with no issues. The support files has been my only delay so far. I will download the support files as per your suggestion and let you know my progress. Thank you very much for your quick reply.

    Thank You

    Wes

    Friday, February 10, 2012 9:49 PM
  • Download Support files.zip using above download link, extract the zip file there you will get Hol_Doctors_DB file.

    Best Regards,

    Abhijit Waikar.
    MCSA 2003 | MCSA:Messaging | MCTS|MCITP:Server Administrator | Microsoft Community Contributor | My Blog

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    Friday, February 10, 2012 9:54 PM
  • You know what's interesting is that I already downloaded this file a few days ago and could not open it due to having no file association. The file downloaded with a DLM extension. I didn't realize that I have to unzip in order to get the support files.

    Thanks Again

    Friday, February 10, 2012 9:58 PM
  • For better assistance related to above query refer AD FS forum:

    http://social.msdn.microsoft.com/Forums/en/Geneva/

    Best Practices for Secure Planning and Deployment of AD FS 2.0.

    http://technet.microsoft.com/en-us/library/adfs2-design-best-practices-for-secure-planning-and-deployment(WS.10).aspx



    Best Regards,

    Sandesh Dubey.

    MCSE|MCSA:Messaging|MCTS|MCITP:Enterprise Adminitrator | My Blog

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    Saturday, February 11, 2012 4:09 AM
  • Hi Abhijit I receive an error when I click on the
    download link

    The system has encountered an unexpected
    error. We apologize for the inconvenience. The issue will be addressed as
    quickly as possible.

    Is there anywhere else that I can download the files?

    Mal


    Saturday, March 03, 2012 3:05 PM
  • Does anyone have an answer to this? All of the links are bad.
    Thursday, March 29, 2012 7:53 PM
  • Hello,

    please ask your question in the following forum in detail http://social.msdn.microsoft.com/Forums/en/Geneva/


    Best regards

    Meinolf Weber
    MVP, MCP, MCTS
    Microsoft MVP - Directory Services
    My Blog: http://msmvps.com/blogs/mweber/

    Disclaimer: This posting is provided AS IS with no warranties or guarantees and confers no rights.

    Thursday, March 29, 2012 8:09 PM
  • Does anyone have an answer to this? All of the links are bad.

    You mean none of the links provided work? Are you behind a Proxy or TMG possibly blocking some of the links?

    .

    Have you posted to the ADFS forum as was suggested? If so, curious what their responses were?

    .

    See if these links work:

    ADFS Step-by-Step Guide - Microsoft TechNet
    Jun 20, 2006 – The Step-by-Step Guide for Active Directory Federation Services provides instructions for setting up Active Directory Federation Services ...
    http://technet.microsoft.com/en-us/library/cc782129(v=ws.10).aspx

    AD FS 2.0 Step-by-Step and How To Guides.
    Published: June 9, 2010. Updated: August 11, 2011. Applies To: Active Directory Federation Services (AD FS) 2.0 ...
    http://technet.microsoft.com/en.../adfs2-step-by-step-guides(v=ws.10).aspx

    Active Directory Federation Services (AD FS) Step-by-Step Guide
    Nov 15, 2007 – Active Directory Federation Services for Windows Server 2008 ... Step 2: Installing AD FS Role Services and Configuring Certificates
    http://technet.microsoft.com/en-us/library/cc731443(v=ws.10).aspx

    Download: ADFS Step-by-Step Guide - Microsoft Download Center ...
    Jun 20, 2006 – This guide provides instructions for setting up Active Directory Federation Services (ADFS) in a small test lab environment.
    http://www.microsoft.com/Download/en/details.aspx?id=15992

    .

    .

    If you have an opportunity to attend the MOC 6426 AD IDAS course, it goes over the whole thing with complete step by step lbas, including how to setup a CA, certificate types, LDS, Federated trusts, etc.
    MOC 6426C: Configuring and Troubleshooting Identity and Access Solutions with Windows Server 2008 Active Directory
    http://www.microsoft.com/learning/en/us/course.aspx?id=6426c
    http://www.webucator.com/microsoft/course/moc-6426-configuring-identity-access-solutions-with-windows-server-2008-active-directory.cfm

    .


    Ace Fekay
    MVP, MCT, MCITP Enterprise Administrator, MCTS Windows 2008 & Exchange 2007 & Exchange 2010, Exchange 2010 Enterprise Administrator, MCSE & MCSA 2003/2000, MCSA Messaging 2003
    Microsoft Certified Trainer
    Microsoft MVP - Directory Services
    Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php

    This posting is provided AS-IS with no warranties or guarantees and confers no rights.

    FaceBook Twitter LinkedIn

    Thursday, March 29, 2012 8:37 PM
  • I'm having the same problem.  The support files called "Support files for Federated Document Collaboration Lab Setup" , located at      http://go.microsoft.com/fwlink/?LinkId=179894     are unavailable.  The link returns a page stating "The system has encountered an unexpected error. We apologize for the inconvenience. The issue will be addressed as quickly as possible."  

    There is a post earlier in this thread, written  by  Abhijit Waikar, directing people to download the files at:

    http://connect.microsoft.com/site642/Downloads/DownloadDetails.aspx?DownloadID=25391

    That link, however, returns the same error page

    Just so there is no confusion, the files that I (and i believe the OP) are referring to, are the files referenced in Step 2 of the guide "How to Set Up the AD FS 2.0 VM Lab Environment for Federated Collaboration" located at:  

    http://technet.microsoft.com/en-us/library/adfs2-how-to-setup-lab-environment-for-federated-collaboration-02(v=ws.10).aspx

    Does anyone know a place to retrieve these the support files?

    Tuesday, May 01, 2012 9:32 PM
  • I'm having the same problem.  The support files called "Support files for Federated Document Collaboration Lab Setup" , located at      http://go.microsoft.com/fwlink/?LinkId=179894     are unavailable.  The link returns a page stating "The system has encountered an unexpected error. We apologize for the inconvenience. The issue will be addressed as quickly as possible."  

    There is a post earlier in this thread, written  by  Abhijit Waikar, directing people to download the files at:

    http://connect.microsoft.com/site642/Downloads/DownloadDetails.aspx?DownloadID=25391

    That link, however, returns the same error page

    Just so there is no confusion, the files that I (and i believe the OP) are referring to, are the files referenced in Step 2 of the guide "How to Set Up the AD FS 2.0 VM Lab Environment for Federated Collaboration" located at:  

    http://technet.microsoft.com/en-us/library/adfs2-how-to-setup-lab-environment-for-federated-collaboration-02(v=ws.10).aspx

    Does anyone know a place to retrieve these the support files?

    You mean this guide?

    How to Set Up the AD FS 2.0 VM Lab Environment for Federated Collaboration
    http://technet.microsoft.com/en-us/library/adfs2-how-to-setup-lab-environment-for-federated-collaboration-00(v=ws.10).aspx

    .

    Here's a list of all the guides:

    AD FS 2.0 Step-by-Step and How To Guides
    http://technet.microsoft.com/en-us/library/adfs2-step-by-step-guides(v=ws.10).aspx

    .

    Why not try the Technet Virtual Lab for ADFS before setting up your own to get a feel for it:

    TechNet Virtual Labs: Identity and Access (IDA)
    http://technet.microsoft.com/en-us/virtuallabs/bb510373

    .


    Ace Fekay
    MVP, MCT, MCITP EA, MCTS Windows 2008/R2, Exchange 2007 & Exchange 2010, Exchange 2010 EA, MCSE & MCSA 2003/2000, MCSA Messaging 2003
    Microsoft Certified Trainer
    Microsoft MVP - Directory Services
    Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php

    This post is provided AS-IS with no warranties or guarantees and confers no rights.

    FaceBookTwitterLinkedIn


    Tuesday, May 01, 2012 10:13 PM
  • Thanks for the reply Ace, however you did not actually address the question.  Yes, i have the link to the guide.  The guide has a link to support files to download, but those files are unavailable.  

    The link to the download page is:

    http://go.microsoft.com/fwlink/?LinkId=179894 

    The download page displays the following error.

    The system has encountered an unexpected error. We apologize for the inconvenience. The issue will be addressed as quickly as possible."

    Do you know where I can find those support files?

    Tuesday, May 01, 2012 10:51 PM
  • You are welcome, Paul.

    believe I gave you the *closest* answer that I know of, as well as alternate suggestions. Unless someone else offers an updated link, then the files are either pulled or your account doesn't have access to that part of the Connect site.

    ON suggestion is to try the Microsoft MOC Companion for the MOC 6426C Course, "Configuring and Troubleshooting Identity and Access Solutions with Windows Server 2008 Active Directory," which provides the ADFS20 setup file, and some reporting tools for the labs in 6426C - found at this link:
    http://www.microsoft.com/learning/en/us/training/companionmoc.aspx

    What also exists for the MOC 6426B is a student CD, which has lots of info, including all the lab step by steps. However, it's no longer available with the "C" version. I have a copy of the "B" CD, but unfortunately, I can't offer it publicly due to my MCT NDA.

    .

    What I can suggest is if you do have a Microsoft Connect account, to contact your rep. If not, the next best thing is the Technet Virtual Labs, as suggested, or attend the course.

    .


    Ace Fekay
    MVP, MCT, MCITP EA, MCTS Windows 2008/R2, Exchange 2007 & Exchange 2010, Exchange 2010 EA, MCSE & MCSA 2003/2000, MCSA Messaging 2003
    Microsoft Certified Trainer
    Microsoft MVP - Directory Services
    Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php

    This post is provided AS-IS with no warranties or guarantees and confers no rights.

    FaceBook Twitter LinkedIn

    Wednesday, May 02, 2012 6:01 AM
  • Understood, and thanks again for the reply.

    My understanding is that, as of now, the "How to Set Up the AD FS 2.0 VM Lab Environment for Federated Collaboration" guide is broken (due to the required support files being inaccessible) and will not work for anyone as written.  Is there an appropriate way to notify Microsoft and request that it be fixed?

    Wednesday, May 02, 2012 6:40 AM
  • Yeah, this is amusing... the guide can be downloaded all day and night.  The real problem is what Paul0193 stated - the "Support files for the Federated Document Collaboration Lab Setup" are not there, when you use the link provided in the guide.  This should be identified and corrected by MSFT.  In the meantime, there has not been any supplemented resource for these files (which prevents completing the lab setup).

    The SQL script is what's required in the steps defined on page 38 of the guide...

    Friday, May 11, 2012 3:30 PM
  • Hi Everyone,

    First, I'd like to apologize that this situation occurred in the first place. I am looking into fixing this missing “Support Files” issue and I can tell you that I am currently in contact with the AD FS product team about this. I plan to have an update to you by 5/16 on what we are going to do about it. In the meantime, I wanted to post something here so that you know we are aware of the issue and are pushing for a resolution.

    Thanks,

    Nick Pierson [MSFT]

    Looking for AD FS 2.0 content? Check out the AD FS 2.0 Content Map on the TechNet wiki. Make sure to leave a comment. J

    Friday, May 11, 2012 8:20 PM
  • Hi Nick,

    I posted about the missing files to our private DS MVP group earlier today. I guess it was escalated to you? That was quick! :-)

    Thank you!

    Ace

    .


    Ace Fekay
    MVP, MCT, MCITP EA, MCTS Windows 2008/R2, Exchange 2007 & Exchange 2010, Exchange 2010 EA, MCSE & MCSA 2003/2000, MCSA Messaging 2003
    Microsoft Certified Trainer
    Microsoft MVP - Directory Services
    Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php

    This post is provided AS-IS with no warranties or guarantees and confers no rights.

    FaceBook Twitter LinkedIn

    Saturday, May 12, 2012 1:36 AM
  • Hi Everyone,

    First, I'd like to apologize that this situation occurred in the first place. I am looking into fixing this missing “Support Files” issue and I can tell you that I am currently in contact with the AD FS product team about this. I plan to have an update to you by 5/16 on what we are going to do about it. In the meantime, I wanted to post something here so that you know we are aware of the issue and are pushing for a resolution.

    Thanks,

    Nick Pierson [MSFT]

    Looking for AD FS 2.0 content? Check out the AD FS 2.0 Content Map on the TechNet wiki. Make sure to leave a comment. J

    That's awesome Nick, thanks for taking the time to look into this and post.  +rep

    • Edited by R_Morrow Monday, May 14, 2012 8:20 PM
    Monday, May 14, 2012 8:19 PM
  • Hey folks,

    Just wanted to get you an update real quick. We are very close to a resolution on this but unfortunately I don't yet have a timeline for when these files will be made available. I will post again on Friday with an update on where we stand. Thanks!

    Nick [MSFT] 

    Thursday, May 17, 2012 6:51 AM
  • Hi Nick,

         Was a resolution ever completed regarding the support files location?  Thanks very much,

    Kevin Cobb

    Thursday, May 24, 2012 11:51 AM
  • I'm also looking for a resolution to this.

    I'm trying to set up my own lab and am stuck at this installation point.

    Any updates?


    Friday, May 25, 2012 5:24 PM
  • Hey again,

    I have great news to announce! Thanks to the great support of our AD FS PMs, Testers and our new AD FS Tech Writer (Gayana) you can now access the Support Files from the following URL on the Download Center:

    http://go.microsoft.com/fwlink/?LinkId=179894

    We have also doubled-back and updated the same forward link we've used all along in the current documentation so that all customers reviewing that content from this point forward will land on this same location.

    Thank you all for bringing this issue up and for being so patient while we got this mess ironed out. :)

    Much obliged!

    Nick [MSFT]

    Looking for AD FS 2.0 content? Check out the AD FS 2.0 Content Map on the TechNet wiki. Make sure to leave a comment. J

    Saturday, May 26, 2012 12:22 AM
  • ITWERKZ!

    Thanx for the quick resolution, Nick (& team)!

    Saturday, May 26, 2012 2:59 PM
  • Thanks, Nick!! :-)

    Ace Fekay
    MVP, MCT, MCITP EA, MCTS Windows 2008/R2, Exchange 2007 & Exchange 2010, Exchange 2010 EA, MCSE & MCSA 2003/2000, MCSA Messaging 2003
    Microsoft Certified Trainer
    Microsoft MVP - Directory Services
    Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php

    This post is provided AS-IS with no warranties or guarantees and confers no rights.

    FaceBook Twitter LinkedIn

    Tuesday, May 29, 2012 4:22 AM
  • The script works as described except for one minor glitch:

    The very last line in HOL_Doctors_db.sql reads as
    "INSERT [dbo].[RS] ([Role], [SharePointGroup]) VALUES (N'clinician', N'sp_contirbutor')"

    IIUC, it should read as:
    "INSERT [dbo].[RS] ([Role], [SharePointGroup]) VALUES (N'clinician', N'sp_contributor')"

    Also, if you've chosen to use SQL 2008 R2, the DB path should be changed from:

    "c:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\HOL Doctors Role.mdf"

    ..to:
    "c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\HOL Doctors Role.mdf"

    ..assuming you're using C: for your DB at all.

    Otherwise, it works as advertised - nice work, folks...

    Thursday, May 31, 2012 6:00 PM