|
|
|
SSC Eights!
      
Group: General Forum Members
Last Login: 2 days ago @ 2:59 AM
Points: 827,
Visits: 1,517
|
|
SQL Server always logs install failures and install successes. On any of my computers the logs are stored in:
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log
In this log directory there is a directory for each install/uninstall you have done.
First checkout the summary_xxxxxxxxxx_landingPage.txt for any errors. if this does not have that much info, next check out the detail_landingpage.txt
Good Luck.
EDIT: Scratch above response! Didnt notice in your first post you mentioned this directory is not to be found!
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:40 PM
Points: 2,610,
Visits: 3,116
|
|
|
|
|
|
SSC Eights!
      
Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:21 AM
Points: 964,
Visits: 632
|
|
I managed to find some logs by searching the entire hard drive for recently created files. Turns out, the log was at C:\Users\<username>\AppData\Local\Temp\SqlSetup.log. Details in the log are:
08/02/2012 06:54:45.744 Required version of Windows Installer is already installed 08/02/2012 06:54:45.746 .Net version 3.5 is already installed. 08/02/2012 06:54:45.747 Windows Installer version 4.5 is already installed. 08/02/2012 06:54:45.748 Patch related actions cannot be run from the local setup.exe, so continuing to run setup.exe from media. 08/02/2012 06:54:45.749 Attempt to initialize SQL setup code group 08/02/2012 06:54:45.751 Attempting to determine security.config file path 08/02/2012 06:54:45.763 Checking to see if policy file exists 08/02/2012 06:54:45.764 .Net security policy file does exist 08/02/2012 06:54:45.766 Attempting to load .Net security policy file 08/02/2012 06:54:45.772 Error: Cannot load .Net security policy file 08/02/2012 06:54:45.774 Error: InitializeSqlSetupCodeGroupCore(64bit) failed 08/02/2012 06:54:45.777 Error: InitializeSqlSetupCodeGroup failed: 0x80004005 08/02/2012 06:54:45.779 Setup closed with exit code: 0x80004005
The line at 06:54:45.748 seems somewhat strange. At least I have an error message I can research now.
Shaun
|
|
|
|
|
SSC Eights!
      
Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:21 AM
Points: 964,
Visits: 632
|
|
Just to bring some closure to this.. The issue seemed to be similar to the one posted in this thread: http://www.sqlservercentral.com/Forums/Topic1262389-391-4.aspx
However, the solution to that issue (caspol.exe -machine –reset) did not work for me. It turns out the problem was with the Security.config file for .NET. Based on the post from MS at http://blogs.msdn.com/b/shawnfa/archive/2004/10/21/245972.aspx, I deleted those files from the locations listed in that post. Still didn't work for me. It turns out, this file is stored in another place not mentioned in the previous website - it was in my C:\Users\<username>\AppData\Roaming directory.
Bottom line, I searched my entire hard drive for all copies of Security.config and Security.cch and deleted them all. That allowed the SP2 program to run.
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: 2 days ago @ 3:44 PM
Points: 168,
Visits: 327
|
|
Hey Shaun,
when you say you deleted all the security.config and cch file, did you delete it for every profile that is on the server or just for your profile? Also i wasn't able to find a security.config or cch file under ...\roaming but did find one under roaming\microsoft\clr security\v2.0.50727.312\
Thanks.
----------------------------- www.cbtr.net .: SQL Backup Admin Tool :.
|
|
|
|
|
SSC Eights!
      
Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:21 AM
Points: 964,
Visits: 632
|
|
You know, it's been so long I don't remember. Maybe delete them from your profile and if the problem persists, delete, move or rename them from others?
Shaun
|
|
|
|