Forum Discussion

RafaC880's avatar
RafaC880
Copper Contributor
Oct 25, 2024

Can't see instance during upgrade

Hello. 

I need help. 

During upgrading the SQL 2012 epress version to the 2022 standard version, I cannot select an instance because the program does not see it. Of course, I can log in to it via SSMS. 

 

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Oct 28, 2024

    RafaC880 , what does

    SELECT @@VERSION

    return?

    If your old SQL Server 2012 32 bit, then you can not perfom an inplace upgrade.

    • RafaC880's avatar
      RafaC880
      Copper Contributor
      Oct 28, 2024

      Microsoft SQL Server 2012 (SP4-GDR) (KB4583465) - 11.0.7507.2 (Intel X86)   Nov  1 2020 00:46:51   Copyright (c) Microsoft Corporation  Express Edition on Windows NT 6.3 <X64> (Build 14393: ) (WOW64) (Hypervisor) 

      • olafhelper's avatar
        olafhelper
        Bronze Contributor
        Oct 29, 2024

         

        RafaC880 wrote:

        Microsoft SQL Server 2012 (SP4-GDR) (KB4583465) - 11.0.7507.2 (Intel X86) 

        RafaC880 , as I guessed, X86 = 32 bit SQL Server.

        You have to install everything around SQL Server new.

  • Mike_Lemay's avatar
    Mike_Lemay
    Copper Contributor
    Nov 12, 2024

    I usually take the opportunity to build a new VM as well with the latest OS.  Do a backup of the 2012 databases and restore them on the 2022 server. Make sure you change the Compatibility Level when done.

Resources