Accedi
 
HomeLibraryRisorseFormazioneDownloadSupportoCommunityForumBlog
Risorse per professionisti IT >
> 
> 
SQL Template

Con risposta SQL Template

  • lunedì 30 aprile 2012 05:49
     
     
    Registrati per votare
    0

    Dears,

    I have created A Standalone 2008 R2 Sysprep SQL Instance with Instance ID: MSSQLSERVER, and I did Sysprep for the OS, then I moved them to MSSCVMMLibrary server in VHD Directory

    I went to VMM 2012, and I have created the following:

    • SQL Server Profile, with providing the following information:
    • SQL Server Deployment: Name: Deployment 1
    • SQL Server Deployment: Instance Name: MSSQLSERVER
    • SQL Server Deployment: Instance ID: MSSQLSERVER
    • SQL Server Deployment:Installatin run as account: Domain\sqladmin
    • Configuration: Media Source: Provide the Path of the Media located on Hyper-V Server
    • SQL Server administrator: I added the needed
    • Security Mode: Windows
    • Service Account: I only have 1 service account sqlsrv
    • Hardware Profile Compatible with Cloud, 2 Processor, NIC assosiated with Hyper-V VIrtual Switch (Successed after Provigening)
    • Gust OS Profile: I provide, the Name, Join to domain (Successed after Provigening)
    • Capability profile: (Successed after Provigening)
    • Here I had Run: Create VM Template Wizard:
    • Select Source: I select the VHD FIle which I Sysprep it as I mentioned in the top of the post, but I got the following MSG:

    ---------------------------
    Create Virtual Machine Wizard
    ---------------------------
    This template specifies options that are not available through standalone VM deployment. To deploy a VM that uses these options, create a single-tier service instead. If you continue, these options will be ignored:

    Windows Server roles and features

    SQL Server deployment


    ---------------------------
    OK  
    ---------------------------

    • Configure Hardware "as mentioned above", Configure OS "mentioned above", Configure Application "I provide nothing", Configure SQL Server "mentioned above"
    • Create VM: I Proivde the same profile mentioned above, + Deploy VM in private cloud

    The Result:

    VM Was provissioned with Correct Hardware Settings, and Correct OS Configuration, BUT SQL instance did not get configured atol.!!

    My questions:

    1. What is the reason that SQL Instance did not get configured? (The process seems like the Create VM Wizard did not work on SQL Section.
    2. The MSG: This template specifies options that are not available through standalone VM deployment. What Does it means? and for which Part of template do this message refer?

    Thanks

     

Tutte le risposte

  • lunedì 30 aprile 2012 06:14
     
     Con risposta
    Registrati per votare
    0

    Hello Jean,

    As far as I tested , sql can be deployed only by Service Template.

    The Summary at VM Template you are having issue can be debug in “%programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\”

    I had done my sql service template with the following link.

    http://blogs.technet.com/b/scvmm/archive/2011/09/27/vmm-2012-sql-server-profile.aspx

    Sincerely,

    Murat Demirkiran

    If the post helps you and remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. www.scvmm2012.com (TR Language)

     
  • martedì 1 maggio 2012 15:33
    Moderatore
     
     Con risposta
    Registrati per votare
    0

    As Murat stated, Applications, SQL servers, server roles and features can only be enabled during deployment if you deploy it as a service template.

    To get a better overview of Services in VMM 2012, please check this white paper I made.

    http://blogs.technet.com/b/privatecloud/archive/2012/02/17/kristian-nese-explains-private-cloud-technical-concepts.aspx

    Kristian (Virtualization and some coffee: http://kristiannese.blogspot.com )