KB484087: Install and setup Microsoft SQL Server Express Metadata database for troubleshooting with MicroStrategy Technical Support

Install and Setup Microsoft SQL Server Express Metadata Database

• Install Microsoft SQL Server Express from here.
  This includes components like the SQL Server Configuration Manager
  

• Install SQL Management Studio from here.
  This tool creates and manages the database.
  
• Open SQL Server Management Studio and sign in using Windows Authentication.
  

• Right-click and click Server Properties > Security.
• Under Server authentication, select SQL Server and Windows Authentication mode. You will be prompted to restart the server.
  

• Right-click on Databases > New Database.
  

• Name your database and click OK.
  

• An empty database is created.
  

• To create a user with standard authentication to use in your DSN creation, expand Security, right-click, and choose New Login.
  

• Select SQL Server authentication to assign a password to your user.
  

• Navigate to User Mapping to assign your user to your database along with their database role. Select sysadmin to allow your user proper access to create and modify tables.
  

• Using the Connectivity Wizard, create a DSN to your database using the IP address of the machine where SQL Server is running and the DB user that you created. The default port that is open is 1433. However, you should confirm the port where SQL Server is communicating through with your network team.
  You can use the command

  netstat -a -n -o

  to list the ports that are open and listening based on the PID, or the process associated with each service. In this instance, find the one associated with SQL Server.
  

• After establishing the new DSN, open Configuration Wizard to configure a new metadata.
• Create a new two-tier project source using the DSN created.
• Duplicate your projects into project source.

For details for creating a backup of your metadata, see KB441138 .
Third Party Software Installation
WARNING: The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.