Hi, I was hoping someone could help me with an SQL Server upgrade. I'm not sure if stating it's a Virtual Machine is pertinent (yet).
I have two instances on my virtual machine (MSSQLSERVER and SQL2008).
MSSQLSERVER stores the SQL Engine
SQL2008 stores AS and RS
and Shared components are: SSMS, Adv_SSMS, Conn, BC, SDK, IS
I have to install SP1 and I'm assuming it's on the MSSQLSERVER (is SQL2008 sharing the Engine with this server?). However, when I attempt to patch SP1, I get a dialogue saying that there are no instances for this patch. When I attempt to upgrade to 2012, I get that SP1 is required.
I'm not getting any options to patch either instance. Has anyone ran into this problem? Could it be because there are shared components? It comes up that the SQL Version is (Hypervisor) so I'm not sure if it's because it's a virtual machine.
Hope someone can help.