If you want to store the MDT DB in a SQL Server database that database administrator (DBA) manages, the DBA must create the MDT DB, and then grant you the appropriate permissions to create the MDT DB objects in the new database. When the database has been created, create the MDT DB in the new database using the Deployment Workbench.

Note   To create the MDT DB, the db_owner database role must exist in the database that the DBA created.

To create the MDT DB in an existing database

1.   The DBA creates the database and grants you DBA permission on the database.

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

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

4.   In the Actions pane, click New Database.

The New DB Wizard starts.

5.   Complete the New DB Wizard using the information in Table 177.

Table 177. 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 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 Microsoft 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 instances if different than the default value).

If you are using the default value, you can leave Port blank.

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 (or recreate) the tables and views in an existing database.

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

Note   If you select a database that has an existing MDT DB, the information in the existing MDT DB tables and views will be lost.

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.

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

3.   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 listed in the details pane of the Deployment Workbench.

Related Topics

Create a New MDT DB