SQL Server 2017 RS实例注册表键值格式异常技术咨询

What's Causing Your Failure? #

The code failure you're hitting stems directly from an invalid value in your SSRS instance registry key. At the path HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\RS, your key named MyInstance has a value of MyInstance—but this doesn't follow SQL Server's required format. For SQL Server 2017, the correct value should be MSRS14.MyInstance.

Official Registry Key Rules for SSRS Instances #

SQL Server enforces a strict naming convention for the Instance Names\RS registry branch to ensure the system can correctly locate and reference your SSRS instance resources:

• Key Name: This is your custom instance name (e.g., MyInstance—this part was correct in your setup)
• Key Value: Must follow the pattern MSRS<MajorVersionNumber>.<InstanceName>
  • The MSRS prefix identifies this as a SQL Server Reporting Services instance
  • The major version number corresponds to your SQL Server release (14 for 2017, 15 for 2019, etc.)
  • The instance name matches the key name, separated by a period

Here's a quick reference for common versions:

• SQL Server 2016: MSRS13.<InstanceName>
• SQL Server 2017: MSRS14.<InstanceName>
• SQL Server 2019: MSRS15.<InstanceName>
• SQL Server 2022: MSRS16.<InstanceName>

This value acts as a pointer to the instance's core configuration files and installation directory. When it's misformatted, SSRS-related code can't resolve the instance properly, leading to the failures you're seeing.

Fix Steps #

To resolve this:

1. Open the Registry Editor by running regedit.exe (you'll need admin rights)
2. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\RS
3. Locate the MyInstance key, right-click it, and select Modify
4. Update the value data to MSRS14.MyInstance
5. Restart the SQL Server Reporting Services service to apply the change

内容的提问来源于stack exchange，提问作者Kalidas Tate