MDT Database Deployments
Trying to create a deployment scenario based around Make & Model (eg Lenovo R Series)
Have entered the Make & Model into MDT's Database, configured the necessary settings to auto select the task sequence, drivers, etc and updated the WIM File and DB, etc
But when I boot into WinPE it still asks me for all the info I have already provided (it should just prompt for PC name and Apps..)
Checked the ZTIGather.log file and there appears to be no problem - IP address is found the WMI query shows the correct make and model, etc
It doesn't seem to be connecting to the Database
The DB is SQL 2005 and on the same server as MDT/WDS,
Named Pipes and TCP/IP are enabled, and even set a SQL Share path on the server
No joy - spent all friggin' day at it and got nowhere...
Connecting to DB
I had a few issues connecting to the DB myself.
It is worth checking the SQL error log for permission errors:
located: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\errorlog
The SQLShare does not need to be built it can be any existing share, when setting it should just be the sharename only, not the full UNC path. eg distribution$ (it already knows the server name)
All this does is to open the pipe using Windows Authetication, no data transfer.
So you customsettings.ini will have DB settings like:
Parameters=UUID, AssetTag, SerialNumber, MacAddress