none
Issues with MDT 2013 U2 and SQLExpress RRS feed

  • Question

  • Hey all, I'm running MDT 2013 U2 on WIndows 2012R2 wuth SQLExpress SP4.  I've used MDT before, but this is the first time I've integrated SQL with it.  I want to use the Make and Model Database feature to deploy only certain apps to a particular model.  Basicall if I image a Surface Pro 4, I want to deploy certain apps to just the surface and nothing else.  

    The issue I'm having is even though the database is configured and everything seems to start ok, it just doesn't apply any app in the make and model properties.  I know I can do it on the task sequence itself and also edit the custom.ini file, but I would rather use the SQL database instead.  I set up the SQL service account and I think I set the permissions on the deployment share correctly...and I set the db_reader property on SQL itself, so I'm not sure what I'm missing.  Is there any really good information out there about working with MDT and SQL?  I've searched but everything I've read doesn't seem to help.  Here is a copy of my custom.ini file if it's helpful. I'm not sure if maybe something I've set might be overriding the task looking at the database.  Thank you.

     [Settings]
    Priority=CSettings, CPackages, CApps, CAdmins, CRoles, Locations, LSettings, LPackages, LApps, LAdmins, LRoles, MMSettings, MMPackages, MMApps, MMAdmins, MMRoles, RSettings, RPackages, RApps, RAdmins, Default
    Properties=MyCustomProperty


    [Default]
    OSInstall=Y
    SkipCapture=NO
    SkipAdminPassword=YES
    SkipProductKey=YES
    SkipComputerName=NO
    SkipComputerBackup=NO
    SkipApplications=YES
    SkipBitLocker=YES
    DoNotCreateExtraPartition=YES
    ApplyGPOPack=NO

    SkipDomainMembership=YES
    JoinDomain=****.***
    DomainAdmin=*****
    DomainAdminDomain=****.***
    DomainAdminPassword=*************
     
    SkipFinalSummary=YES
    SkipLocaleSelection=YES 
    KeyboardLocale=en-US
    UserLocale=en-US 
    UILanguage=en-US 
    SkipPackageDisplay=YES 
    SkipProductKey=YES 
    SkipSummary=YES
    SkipTaskSequence=NO
    SkipTimeZone=YES
    TimeZoneName=Eastern Standard Time
    FinishAction=REBOOT
     
    SkipUserData=Yes
    EventService=http://HSVM-MDT01:9800

    [CSettings]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=ComputerSettings
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR

    [CPackages]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=ComputerPackages
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR
    Order=Sequence

    [CApps]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=ComputerApplications
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR
    Order=Sequence

    [CAdmins]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=ComputerAdministrators
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR

    [CRoles]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=ComputerRoles
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR

    [Locations]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=Locations
    Parameters=DefaultGateway

    [LSettings]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=LocationSettings
    Parameters=DefaultGateway

    [LPackages]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=LocationPackages
    Parameters=DefaultGateway
    Order=Sequence

    [LApps]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=LocationApplications
    Parameters=DefaultGateway
    Order=Sequence

    [LAdmins]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=LocationAdministrators
    Parameters=DefaultGateway

    [LRoles]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=LocationRoles
    Parameters=DefaultGateway

    [MMSettings]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=MakeModelSettings
    Parameters=Make, Model

    [MMPackages]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=MakeModelPackages
    Parameters=Make, Model
    Order=Sequence

    [MMApps]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=MakeModelApplications
    Parameters=Make, Model
    Order=Sequence

    [MMAdmins]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=MakeModelAdministrators
    Parameters=Make, Model

    [MMRoles]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=MakeModelRoles
    Parameters=Make, Model

    [RSettings]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=RoleSettings
    Parameters=Role

    [RPackages]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=RolePackages
    Parameters=Role
    Order=Sequence

    [RApps]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=RoleApplications
    Parameters=Role
    Order=Sequence

    [RAdmins]
    SQLServer=HSVM-MDT01
    Instance=SQLExpress
    Database=MDT01
    Netlib=DBNMPNTW
    SQLShare=DeploymentShare$
    Table=RoleAdministrators
    Parameters=Role
    Thursday, February 22, 2018 7:54 PM

All replies

  • Make sure it's configure correctly to use Named Pipes and that your Firewall allows the needed ports

    Use the MDT database to stage Windows 10 deployment information


    Daniel Vega

    Friday, February 23, 2018 4:53 PM
  • Did that.  Named pipes and 1433 and 1434 open.  Even turned the firewall off.  I even looked a bit more closely at it and it when it applies the custom.ini file, it just breezes over it.  It even skips a few settings like MMSettings, LROLES, etc even though they're listed.
    Friday, February 23, 2018 6:27 PM
  • SO I decided to do away with the database and instead just manually put the models and their specific applications on the customsettings.ini file.  it looks as though I may have a problem with the ini file itself.  For some reason it's onl;y reading the default section and not anything else.  Here is my file.

    [Settings]
    Priority=Model,Default
    Properties=_SMSTSOrgName

    [Surface Book]
    XResolution=3000
    YResolution=2000
    Applications001={83faa220-dcd6-47cc-a692-c1832197f6be}
    Applications002={984ff02e-143b-4440-95ca-20fa140341ae}
    Applications003={b85126bc-3a8a-480c-a56e-9993096987b4}
    Applications004={bcab51b4-51d3-458f-81fa-006a97a81568}
    Applications005={61ff585a-69cd-4562-8ac7-42e2dcaf9f94}
    Applications006={8c1a98fb-8bbb-4087-8b98-cb2071b70645}

    [Surface Pro 4]
    XResolution=2736
    YResolution=1824
    Applications001={83faa220-dcd6-47cc-a692-c1832197f6be}
    Applications002={984ff02e-143b-4440-95ca-20fa140341ae}
    Applications003={b85126bc-3a8a-480c-a56e-9993096987b4}
    Applications004={bcab51b4-51d3-458f-81fa-006a97a81568}
    Applications005={61ff585a-69cd-4562-8ac7-42e2dcaf9f94}
    Applications006={8c1a98fb-8bbb-4087-8b98-cb2071b70645}

    [Surface 3]
    XResolution=1920
    YResolution=1280
    Applications001={83faa220-dcd6-47cc-a692-c1832197f6be}
    Applications002={984ff02e-143b-4440-95ca-20fa140341ae}
    Applications003={b85126bc-3a8a-480c-a56e-9993096987b4}
    Applications004={bcab51b4-51d3-458f-81fa-006a97a81568}
    Applications005={61ff585a-69cd-4562-8ac7-42e2dcaf9f94}
    Applications006={8c1a98fb-8bbb-4087-8b98-cb2071b70645}

    [Default]
    _SMSTSORGNAME=Sayreville Public Schools
    _SMSTSPackageName=%TaskSequenceName%

    OSInstall=Y
    SkipCapture=NO
    SkipAdminPassword=YES
    SkipProductKey=YES
    SkipComputerName=NO
    SkipComputerBackup=NO
    SkipApplications=YES
    SkipBitLocker=YES
    DoNotCreateExtraPartition=YES
    ApplyGPOPack=NO

    SkipDomainMembership=YES
    JoinDomain=****.*** 
    DomainAdmin=*******
    DomainAdminDomain=****.***
    DomainAdminPassword=******
     
    SkipFinalSummary=YES
    SkipLocaleSelection=YES 
    KeyboardLocale=en-US
    UserLocale=en-US 
    UILanguage=en-US 
    SkipPackageDisplay=YES 
    SkipProductKey=YES 
    SkipSummary=YES
    SkipTaskSequence=NO
    SkipTimeZone=YES
    TimeZoneName=Eastern Standard Time
    FinishAction=REBOOT
     
    SkipUserData=Yes
    EventService=http://HSVM-MDT01:9800
    Friday, February 23, 2018 7:45 PM
  • You can save yourself a bunch of the repeat info by doing something like this

    [Settings]
    Priority=Make, Default
    Properties=
    
    [Microsoft Corporation]
    Applications001={83faa220-dcd6-47cc-a692-c1832197f6be}
    Applications002={984ff02e-143b-4440-95ca-20fa140341ae}
    Applications003={b85126bc-3a8a-480c-a56e-9993096987b4}
    Applications004={bcab51b4-51d3-458f-81fa-006a97a81568}
    Applications005={61ff585a-69cd-4562-8ac7-42e2dcaf9f94}
    Applications006={8c1a98fb-8bbb-4087-8b98-cb2071b70645}
    Subsection=Microsoft-%Model%
    
    [Microsoft-Surface Book]
    XResolution=3000
    YResolution=2000
    
    [Microsoft-Surface Pro 4]
    XResolution=2736
    YResolution=1824
    
    [Microsoft-Surface 3]
    XResolution=1920
    YResolution=1280
    
    [Default]
    _SMSTSORGNAME=Sayreville Public Schools

    FYI _SMSTSOrgName is a built-in variable and doesn't need to be listed in properties. 


    Daniel Vega

    • Proposed as answer by Dan_Vega Tuesday, March 27, 2018 9:06 PM
    Friday, March 2, 2018 7:53 PM
  • Having not worked with Microsoft hardware in a few years and combine that with you stating your deployment is skipping the Model and going straight to Default, you may want to double check your Model string from your BDD.log.  See if there could be a leading or trailing space or that the Model Name is correct.

    If in full OS, run a command window and use the command

    WMIC computersystem get model

    Tuesday, March 13, 2018 4:04 AM
  • I made a batch file that runs this:

    @echo off
    powershell -command "& {gwmi Win32_Bios | Select SMBIOSBIOSVersion, SerialNumber | ft; gwmi Win32_ComputerSystem | Select Model, Manufacturer | ft; gwmi Win32_SystemEnclosure | Select SMBIOSAssetTag | ft }"
    pause

    It gives you a nice layout of what your hardware is, along with serial number and asset tag.


    Daniel Vega

    Tuesday, March 13, 2018 1:26 PM