MDT Database Deployments

[Gatt]

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...

 

:confused:

[megaman]

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:

 

[CSettings]

SQLServer=MYSERVERNAME

Instance=DEPLOYMENT

Database=DEPLOYDB

Netlib=DBNMPNTW

SQLShare=distribution$

Table=ComputerSettings

Parameters=UUID, AssetTag, SerialNumber, MacAddress

ParameterCondition=OR

 

Good luck,

Mike