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). 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. |
Database |
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). 2. Click Next. |
Summary |
Review the information in the Details box, and then click Next. |
Confirmation |
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