Creating the MDT 2010 Database

Before configuring the database, you must create it in SQL Server. Deployment Workbench creates this database automatically by using the New DB Wizard. Of course, this section assumes that SQL Server is already installed and configured locally or remotely in your environment and that you have permission to create databases.

To create the MDT 2010 database in SQL Server, perform the following steps:

1. In Deployment Workbench, right-click Database and then click New Database. Database is located under Advanced Configuration in the deployment share.
2. On the SQL Server Details page, in the SQL Server Name box, type the name of the server hosting SQL Server and click Next. If you want, provide an instance and port and specify the network library to use for the connection.
3. On the Database page, choose Create A New Database, type the name of the database in the Database text box, and then click Next. You can also choose to repair or connect to an existing database.
4. If you want, on the SQL Share page, type the name of any share on the server running SQL Server and then click Finish. MDT 2010 uses this share only if necessary to create a secure connection to the computer running SQL Server when using integrated security. Specify this share only if the Windows Deployment Wizard is not able to connect to SQL Server during deployment. The wizard will attempt to connect to this share using the connection credentials specified as described in the section titled "Configuring Resources" earlier in this tutorial.