FIX: A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

Most often we may come across issues like below when tried to connect Analysis Service Data Connection:
"A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)"

To fix this follow below steps:
Step 1: Navigate to Programs|SQL Server XXXX|Configuration tools|SQL Server Surface Area Configuration

Step 2: Change the service account to local system as shown below:

How to shrink database and database logical files

1. Execute the below command to find the logical file names and their location in local folder:

USE <DB_NAME>
Execute SP_Helpfile

E.g., Use AdventureWorks
         Execute SP_HelpFile

2. Command to shrink a database:

    DBCC SHRINKDATBASE (AdventureWorks)

3. Command to Shrink Logical files (.MDF, .LDF):
    If the MDF logical file name of AdventureWorks database is AdventureWorks_Data
   Then the command is,

   DBCC SHRINKFILE (AdventureWorks_Data)

MDF, NDF and LDF Files in DQL Database

Primary data files: MDF FilesPrimary data file is the starting point of the database. It points to the other files in the database. Therefore, every database has one primary data file. Also, all the data in the database objects (tables, stored procedures, views, triggers.. etc.) are stored in the primary data files. The recommended and the most common file name extension for primary data files is .mdf.

Secondary data files: NDF Files
You can only have one primary data file for a database. Rest made up by secondary data files. But its not necessary to have a secondary data file. Therefore some databases may not have any secondary data file. But its also possible to have multiple secondary data files for a single database. .ndf is usually recommended to denote secondary data files. It’s also possible to store the secondary data file in a separate physical drive than the one which primary data file is stored.

Log filesL LDF files
Log files in SQL Server databases hold all the log information. Those information can be later used to recover the database. Size of the log file is determined by the logging level you have set up on the database. There must be at least one log file for each database. But it is also possible to have more than one log file for a single database. The recommended file name extension for log files is .ldf.