In instances where you are the SQL Server DBA or have the necessary permissions, you can create the new MDT DB, and then create the MDT DB database objects in the new database using the Deployment Workbench.

Note   To create the MDT DB, you need the sysadmin or dbcreator server roles.

To create the MDT DB in a new database

1.   Click Start, and then point to All Programs. Point to Microsoft Deployment Toolkit, and then click Deployment Workbench.

2.   In the Deployment Workbench console tree, go to Deployment Workbench/Deployment Shares/deployment_share/Advanced Configuration/Database (where deployment_share is the name of the deployment share in which you will add the application).

3.   In the Actions pane, click New Database.

The New DB Wizard starts.

4.   Complete the New DB Wizard using the information in Table 178.

Table 178. Information for Completing the New DB Wizard

On this wizard page

Do this

SQL Server Details

1.   In SQL Server name, type computer_name (where computer_name is the name of the computer running SQL Server).

2.   In Instance, type instance_name (where instance_name is the name of the SQL Server instance on the computer running SQL Server).

If you are using SQL Server installed as the default instance, you can leave Instance blank. If you are using SQL Server Express, type SQLExpress for the instance name.

3.   In Port, type port_number (where port_number is the TCP port number for the SQL Server instance if different than the default value).

4.   In Network Library, select network_library (where network_library is the network library used to communicate with SQL Server and can be either Named Pipes or TCP/IP Sockets).

5.   Click Next.


1.   Select Create a new database.

2.   In Database, type database_name (where database_name is the name of the database in which you want to store the MDT DB).

3.   Click Next.

SQL Share

1.   In SQL Share, type share_name (where share_name is the name of a network shared folder on the computer specified on the SQL Server Details wizard page).

This text box is required for Windows PE to connect to the database using the Windows Integrated Security with Named Pipes protocol. Windows PE connects to the network shared folder, establishing a network connection to the server so that Windows Integrated Security in SQL Server authenticates correctly.

If Windows PE is not connecting to the database using this protocol, you can leave SQL Share blank.

2.   Click Next.


Review the information in the Details box, and then click Next.


Tip   You can click Save Output to save the output of the wizard to a file. You can also click View Script to view the Windows PowerShell scripts used to perform the wizard tasks.

Click Finish.


The New DB Wizard finishes. The database configuration information is shown in the details pane of the Deployment Workbench.

Related Topics

Create a New MDT DB