January 28, 2015 at 10:40 am
Hi, I have a SQL Server 2012 installation that is at SP1 level. I need to patch it with SP2 but the SP2 installer does not see the instance. How does the patch installer find SQL instances that are installed? For other instances, it displays the discovered instance and whether or not it qualifies for the update. In this case, the installer does not seem to know the instance is even out there.
It is non-prod so I don't really want to engage Microsoft support but would like to get this instance patched as it has been on my mind since SP2 came out.
I've tried the most obvious things like the /allinstances or /instancename=<the instance name> command line switches but it doesn't help.
Any suggestions for a fix?
Thanks much,
Howard
January 28, 2015 at 10:56 am
can you connect to the instance and run
select @@version
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 28, 2015 at 11:00 am
Thanks for your response Perry. I'm stuck at SP1 on this one.
Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
Oct 19 2012 13:38:57
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply