“Unsupported IIS Security Modes for Report Server” failed When you try to upgrade SQL 2005 to 2014

This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.

Issue Background:

=======

Customer is running SQL Server 2005(X64) on Windows Server 2008, and they want to upgrade to SQL Server 2014 with in-place(can't accept side by side). But during the upgrading, the following rules are failed, this is related to Reporting Service, but actually customer never use it.

Rule "Unsupported IIS Security Modes for Report Server" failed.

Rule "Unsupported IIS Security Modes for Report Manager" failed.

Rule "Client Certificate Required for Report Server" failed.

Rule "Client Certificate Required for Report Manager" failed.

44.png

 

Troubleshooting Steps:

========

1. As this related to SSRS, so check if we can ignore the SSRS service only upgrade the other SQL service, but we can't change the feature to be upgraded. 

http://download.microsoft.com/download/7/1/5/715BDFA7-51B6-4D7B-AF17-61E78C7E538F/SQL_Server_2014_Upgrade_technical_guide.pdf 

 

2. And then discussed with customer about the side by side upgrading, but they can't accept. 

 

3. Suggest customer to upgrade the OS first, but we also can't make sure this will 100% work.

 

4. Then we go back to the error itself, this is related to IIS. So I open up Server Manager, and check IIS related service, WAS and W3SVC already running, but we saw IIS Admin Service is stopped. 

666.png

 

5. We go to Services.msc and then set the Startup type to Manual and then start this “IIS Admin Service”, and then after re-run the rule, all rules are passed. 

6. And then we continue Upgrading, after a while, upgrade completed without any other issue, 

3.png

 

Solution:

======

GO to Server Manager, and check IIS related service, make sure IIS related service is up and running, especially for WAS/W3SVC/IIS Admin Service. 

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.