Removal of IIS service from Tableau Servers.

Objective: This blog will help you resolve the issue when you observe the Tableau Gateway service is not coming up after Tableau restart. The Tableau status goes into a Degraded state. By default, IIS services are running on Port 80. IIS and the Gateway process both occupy port 80 so we decided to remove the unwanted IIS service from the Tableau server VM.

Tableau

Introduction:

Internet Information Services, also known as IIS, is a Microsoft web server that runs on the Windows operating system and is used to exchange static and dynamic web content with internet users. IIS can be used to host, deploy, and manage web applications using technologies such as ASP.NET and PHP.

Workaround

1. Open the Microsoft Azure Home Page and click on ‘Virtual Machines’.
2. Search Tableau VMs from the list.

3. Connect to the VM where the tableau server is running by using RDP.

4. Go to Windows Search and type ‘Command Prompt’. After opening the Command Prompt, Type the below command.

Run the command to check the status of Tableau servers:

tsm status

(When the status is showing a running state then only proceed to stop the server otherwise hold the activity and troubleshoot the tableau server issues).

tsm stop

(It will take some time to stop the Service, Wait until Tableau Server is stopped. When it all shows stopped)

Removal of IIS

1. Go to Windows Search look for “Server Manager” and open it.

2. Now click on the Manage option on the right corner and then you will see the Remove Roles and Features option and then select that option.

3. Click on the “Next”

4. Now you will see that the server is automatically selected. You need to click on “Next”.

5. After that, you will see the list of Server Roles. Look for Web Server (IIS) in the roles list.

6. Now untick the box next to this Web Server (IIS) role and click on Next.

7. After that click on the next till you are on the confirmation page as shown below. Verify the role and services and click on the remove option.

Reboot the Tableau server VM

1. Go back to Azure VM’s portal and ‘Restart’ the VM.

2. When Vm has completely restarted check the Tableau server status.
If it is in a stopped state run the following command

tsm start

You can view the server process status can be by running a TSM CLI command or by accessing TSM Web UI or Admin pages on Tableau Server.

Viewing process status with TSM CLI Run the command:

tsm status -v

This command outputs all of the processes that are configured on the instance and their corresponding status viewing process status in web UI Check https://<Vm name>:8850/ for status.

All the services should be in working Process for all nodes, kindly check carefully.

Note: If you are facing an issue stopping or starting the Tableaue services follow the below workaround

1. Go to the Tableau server directory where you installed it and then go to the path of the script where the Tableau program files are located.

TableauServer => packages => select the latest folder for scripts

I:\TableauServer\packages\scripts.20221.22.0902.1602

2. First stop the administrative services by issuing the following command

stop-administrative-services.cmd

3. Check the status of whether all the administrative services are stopped or not with the help of the following command.

stop-administrative-services.cmd

4. Now start the administrative services.

start-administrative-services.cmd

Now you can check the status by going into Windows services and looking for Tableau services.

After the successful completion of these steps, you can proceed with stopping and starting the tableau server by using tsm commands.