This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 4%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
担当者殿
いつもお世話になっております。名桜大学のメディアネットワークセンターです。
Windows2019サーバーにSQL Server 2008 が入っており、SQL Serverのサポートが切れている為、Updateを行いたいと思っています。
SQL2016やSQL2017にアップグレードしようとすると、「機能の選択」という部分で、"アップグレードする機能が選択されていません"と表示され
アップグレードが行えない状態です。
このような場合、どのように対処したら宜しいのでしょうか？
This is an English spoken forum, so please post your question in English.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 3%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
SQL Server 2008 RTM does not have any SQL Server-related service pack installed. You may try to install the SQL Server 2008 SP4 first and then try to upgrade it to SQL Server 2016.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 45%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Agreed.
As a general rule, before you do an upgrade you'll need to install the latest service pack for that system at the time "the version you're upgrading to" exists.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 84%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
Hi @MNC サポート ，
Welcome to Microsoft Q&A！
Please use statement select @@VERSION to check version of SQL Server，then confirm whether your version of SQL Server meets the upgrade conditions according to the following:
https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades?view=sql-server-ver15
Please check whether you SQL Server is 64-bit, and to upgrade to SQL Server 2016, you must be running a supported operating system because SQL Server 2016 (13.x) and 2017(14.x) is only available for 64-bit platforms. Cross-platform upgrade is not supported, please verify that the functionality you are currently using is supported in the edition to which you are moving.
こんにちは、 Yufeishao-msft 様
コメントありがとうございます。
バージョンを確認したら、「10.00.1600.22」でした。
"SQL Server 2008 RTM"のようですが、頂いたリストになさそうですね。
your version is too low, you can try to restore SQL Server 2008 backup to SQL Server 2016, or find another upgrade method, but all need to pay attention to compatibility issues.