Documentation Center

Creating databases for your sample single-machine installation

Run a number of PowerShell scripts to create the databases for Content Manager and Content Delivery.

Before you begin

Procedure

  1. Start Windows Explorer.
  2. Create a folder c:\SDLDBinstall\ and a subfolder c:\SDLDBinstall\Scripts\.
  3. Go to your SDL Web installation media and go to the Database\ folder.
  4. Copy the subfolder mssql\ to c:\SDLDBinstall\.
  5. Go to the installation media subfolder Database\Scripts\.
  6. Copy the installation media files Tridion.Database.Management.dll and Utilities.ps1 to c:\SDLDBinstall\Scripts\.
  7. Copy the installation media subfolder mssql\ to c:\SDLDBinstall\Scripts\.
  8. Copy the installation media subfolder Tools\ to c:\SDLDBinstall\Scripts\.
  9. Right-click c:\SDLDBinstall\Scripts\Tridion.Database.Management.dll and select Properties from the context menu. If you see an Unblock button, select it and select OK.
  10. Start PowerShell as an administrator-level user by right-clicking the PowerShell icon and selecting Run as administrator, even if you are already logged in to Windows as an administrator-level user.
    The PowerShell console opens.
  11. Enter the following command:
    Set-ExecutionPolicy Unrestricted

    Answer A (All) when prompted.

  12. Go to c:\SDLDBinstall\mssql\.
  13. Run the following command:
    & '.\Install Content Manager database.ps1'
  14. Confirm the default database server name, (local), and the default administator account name, sa.
  15. Enter the password for sa.
  16. Confirm the default database name, Tridion_cm, and the default database account name, TCMDBUser.
  17. Enter and confirm as the password for this user: tridion.
  18. Confirm that you do not want to create another user: N.
  19. Replace the default full user name of the SDL Web Content Manager MTSUser account, DOMAIN\MTSUser (where DOMAIN is your domain) with the value .\MTSUser.
  20. Confirm the default SDL Web Administrator User Name, MACHINE\Administrator, where MACHINE is the name of your machine, as well as the default name of the local system account, NT AUTHORITY\SYSTEM.
  21. Confirm that you want to proceed: Y.
    The script installs the database.
  22. Run the following command:
    & '.\Install Topology Manager database.ps1'
  23. Confirm the default database server name, (local), and the default administator account name, sa.
  24. Enter the password for sa.
  25. Confirm the default database name, Tridion_Topology, and the default database account name, TTMDBUser.
  26. Enter and confirm as the password for this user: tridion.
  27. Confirm that you do not want to create another user: N.
  28. Confirm that you want to proceed: Y.
    The script installs the database.
  29. Run the following command:
    & '.\Install Content Data Store.ps1'
  30. Confirm the default database server name, (local), and the default administator account name, sa.
  31. Enter the password for sa.
  32. Confirm the default database name, Tridion_Broker, and the default database account name, TridionBrokerUser.
  33. Enter and confirm as the password for this user: tridion.
  34. Confirm that you want to proceed: Y.
    The script installs the database.
  35. Run the same command again:
    & '.\Install Content Data Store.ps1'
  36. Confirm the default database server name, (local), and the default administator account name, sa.
  37. Enter the password for sa.
  38. Replace the default database name, Tridion_Broker, with SDLWeb_xpm_sample.
  39. Confirm the default database account name, TridionBrokerUser.
  40. Confirm that you want to proceed: Y.
    The script installs the database.
  41. Close PowerShell.
  42. Remove the folder c:\SDLDBinstall\ to free up disk space on your machine.