How to configure Visual studio load test Database manually?

To configure Visual studio load test Database manually perform following steps:

1. Open a Visual Studio Command prompt. Type the following text: On a 32-bit version of Windows type: cd “c:\Program Files\Microsoft Visual Studio 12.0\Common7\IDE” -or- On a 64-bit version of Windows type: cd “c:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE”
2. In that folder, type the following text:

• SQL Express: SQLCMD /S localhost\sqlexpress /i loadtestresultsrepository.sql
• SQL: You can install the database to any existing SQL server. For example, if you had a SQL server named Server1 you would use the following command: SQLCMD /S Server1 -i loadtestresultsrepository.sql

Caution The parameters are case sensitive. You must type uppercase S and lowercase i. SQLCMD /S pintu-home -i loadtestresultsrepository.sql

You might also need to specify a user name and password so that you can connect to Server. If so, you would use the following command: SQLCMD /S Server1 -U -P -i loadtestresultsrepository.sql Caution: The parameters are case sensitive.

3. On the Load Test toolbar, choose Manage Test Controllers. The Manage Test Controllers dialog box is displayed.
4. In the Load Test Results Connection String, click the browse button (…) to display the Connection Properties dialog box. Note:If you change the connection string for a controller, then you must select the controller.
5. In Server Name, type localhost\sqlexpress or the name of the server that you used in step 2 such as Server1.
6. Under Log on to the server, choose Use Windows Authentication.
7. Under Connect to a database, choose Select or enter a database name. Select LoadTest from the drop-down list box.
8. Choose OK.
9. Choose Close in the Administer Test Controller dialog box