There are multiple issues with a server I manage, we cannot start management studio on it and when we try to install patches to SQL Server the setup never shows up.
I run the patch as an administrator, it shows me that some files are being extracted to a temp folder, then a CMD window opens for a split second and closes immediately after.
I have looked around a bit to find a solution but can't quite decide where to start from.
Here is a link of someone saying he ran caspol.exe
to fix a somewhat similar issue
What's caspol
anyways? Having never used it I don't really want to create more issues by not knowing what it should be used for.0
Here is another link saying I need to add registry keys for my installation to begin:
Here is my server's select @@version
query result :
Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) Mar 29 2009 10:27:29 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition on Windows NT 6.0 (Build 6002: Service Pack 2) (VM)
The server is a windows server 2008 32-bit
The patch setup creates the following log when it fails :
03/17/2016 13:58:13.308 ======================================================================
03/17/2016 13:58:13.309 Setup launched
03/17/2016 13:58:13.310 Attempting to determine media source
03/17/2016 13:58:13.311 Media source value not specified on command line argument.
03/17/2016 13:58:13.390 Setup is launched from media directly so default the value to the current folder.
03/17/2016 13:58:13.391 Media source: g:\e89cdf338f18c1307f\
03/17/2016 13:58:13.391 Attempt to determine media layout based on file 'g:\e89cdf338f18c1307f\mediainfo.xml'.
03/17/2016 13:58:13.433 The folder 'g:\e89cdf338f18c1307f\' does not contain a valid media info file 'mediainfo.xml'.
03/17/2016 13:58:13.434 Setup closed with exit code: 0x84C4001E
03/17/2016 13:58:13.484 ======================================================================
It might be good to add that the windows search is not working, as you may observe in the following image :
Maybe the setup is trying to look for files but fails as it cannot search for them ?
If this was your server, what would be the first step of troubleshooting you'd go through ?