Create a Database Connection for Analysis Services

After creating a database instance as described in Creating a Database Instance for Analysis Services 2012/2014/2016/2017/2019/Azure, create a database connection:

1. Click New.
2. Provide the following information as required:

   Database connection name: This is the name to distinguish the database connection from database connections for other database instances.

   URL: This is the URL of the XMLA Provider that was configured for HTTP access. For example: http://fully-qualified-machinename/MicroStrategyMDX/MicroStrategyMDX.asmx

   The fully-qualified-machinename is usually of the form machine.domain.company.com. You can also use the IP address as the fully-qualified-machinename. The URL is not case sensitive.

   DSI: Type the fully qualified machine name or the IP address of the machine where the Microsoft Analysis Services server is running.

   Catalog: Use Microsoft's SQL Server Management Studio to view the Analysis Server which contains the cubes to work with in Strategy. The database that contains the cube becomes the catalog.

Upon creating the database connection, see Complete the Connection to Analysis Services for next steps.