Install MDT application based on Make/Model using SQL Database



    I am trying to install applications using Deployment Toolkit (MDT) 2013 Update 2, based on the specific Manufacturer and Model of the client computer. But the applications are not installing.

    I have installed SQL Express using the default settings (which creates a database called SQLEXPRESS)

    I have installed SQL Management Studio and given access rights to the database to an account called MDT_BA. As per the following article.

    I have gone into the SQL Configuration Manager and enabled 'Named Pipes'

    I have created an inbound Firewall rule for TCP port 1433 and UDP port 1434 and also added an inbound rule for "C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\Sqlservr.exe"

    I manually started the "SQL Server Browser" service.

    I have created my MDT database using the following settings.

    1. Server Name: testmdt01.test.local
    2. Instance: SQLEXPRESS
    3. Port: (blank)
    4. Network Library: Named Pipes

    I have run a Powershell command to query the Make/Model on my client machine.

    Get-WmiObject Win32_Computersystem `
    | Format-List Name, manufacturer, model, SystemType

    ...and then added the returned values into the MDT 'Make and Model' table

    • Make = HP
    • Model = HP ProBook 450 G4

    Finally, I added a Task Sequence to "Install Applications" (Not sure if this is required) and set the value 'SkipApplications=YES' in the Custom.ini to skip the applications screen.

    I have also checked the applications packages by installing in the traditional way using the Task Sequence.

    Any pointers/help greatly appreciated.

    Saturday, March 18, 2017 7:09 AM


All replies