Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2008 Installation Issues - Issues and Workarounds Expand / Collapse
Author
Message
Posted Thursday, April 28, 2011 12:01 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 21, 2014 9:36 AM
Points: 172, Visits: 567
Comments posted to this topic are about the item SQL Server 2008 Installation Issues - Issues and Workarounds


Post #1099993
Posted Thursday, April 28, 2011 7:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 2, 2012 10:47 AM
Points: 2, Visits: 40
Just an FYI that may help those troubled by SQL2005-->2008R2 x64 upgrade.

Ran into an issue recently upgrading MS SQL 2005 to 2008 R2 x64 on a MS Server 2003 R2 Std x64 SP2. Couldn't figure out issues around the following app related message:
"Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' The system cannot find the file specified."

Eventually after some back and forth on google and stackoverflow we installed these in the following order and it solved the problem.

SQL 2005 Feature Packs (64 bit)
• sqlncli_x64.msi - 02/10/07 {061F210D-A57D-45A8-B93A-73A51FFD2819}
• SQLServer2005_NS_x64.msi - 02/10/07 {7C1551DA-0003-4B79-B169-9312FAACC642}
• SQLServer2005_XMO_x64.msi - 02/10/07 {4A1F4140-3848-4AAE-AD67-43CD340748B6}

SQL 2008 Feature Packs (64 bit)
• msxml6_x64.msi - 12/04/06 {6A3B8AE9-3F13-4302-A5AE-C51A0BA1592E}
• sqlncli.msi - 09/17/10 {06C6C7E0-23E3-46BB-A6F9-4A5A65A3F6A3}
• SQLSysClrTypes.msi - 09/17/10 {7D554282-F04F-4137-9E78-7958D6FCCC01}
• SharedManagementObjects.msi - 09/17/10 {9B975EF9-C188-4F6F-8B0F-11D141B4D542}

SQL 2008 R2 Feature Packs (64 bit)
• msxml6-KB954459-enu-amd64.exe - 04/06/11 version 6.2.0029.0
• sqlncli.msi - 04/04/10 {030FA491-C310-47EF-9D8E-552FB5537551}
• SQLSysClrTypes.msi - 04/04/10 {7CA02314-2C0A-4A25-88B2-33FCF4561B91}
• SharedManagementObjects.msi - 04/04/10 {D2852190-83DE-4AF3-A79B-4642206F0F70}
Post #1100219
Posted Thursday, April 28, 2011 7:43 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 21, 2014 9:36 AM
Points: 172, Visits: 567
Thank you, econwatch - I, as well as the sql audience, appreciate sharing your experiences and solutions with upgrading.

This was one issue that dogged me during an installation, and wanted to just share helpful information.

I authored a second article with some additional installation issues and workarounds, that I believe will be published shortly.

Never a shortage for issues - so all the more welcome everyone's experiences and resolutions.....

RP



Post #1100237
Posted Thursday, April 28, 2011 12:17 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 9:54 AM
Points: 498, Visits: 981
FYI, "alert(navigator.userAgent)" in the browser address bar did not work for me in IE 9.

... and the forum software happily deleted the 'j a v a s c r i p t :' from the post. Which, I suppose is a 'good thing'.

Steve G.



Post #1100463
Posted Thursday, April 28, 2011 12:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 2, 2012 10:47 AM
Points: 2, Visits: 40
Also tested on IE9 and noticed the same thing.
IE gets rid of the 'j a v a s c r i p t :' text.
Just re-wrote it in front of "alert(navigator.userAgent)" FTW.

Post #1100485
Posted Thursday, April 28, 2011 12:57 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 9:54 AM
Points: 498, Visits: 981
Hey, that works! Cool!


Post #1100503
Posted Friday, April 29, 2011 8:22 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 9, 2012 5:42 PM
Points: 3, Visits: 28
I do not wish to denigrate this article but am I the first one reading it thinking how absurd it is that so many hoops must be navigated to troubleshoot what appears to be an abject failure on the part of the software publisher to maintain some basic integrity in their product line?
The problem here is that SQL Server 2008 installer erroneously states that 3.5 SP1 has not been installed when in fact it has already been installed.
Really?
For 21st century technology this is pretty sad.
Post #1101131
Posted Tuesday, May 3, 2011 1:06 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, November 17, 2014 1:47 AM
Points: 227, Visits: 281
I've installed both SQL 2008 and SQL 2008 R2 (both 64bit versions) on Windows 7 Pro 64bit and had zero installation issues.
I must be lucky.
Post #1102140
Posted Tuesday, May 3, 2011 1:09 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, November 17, 2014 1:47 AM
Points: 227, Visits: 281
I guess the whole check what version of .NET you have installed via your browser is supposed to be quick?
Why not simply go Control Panel >> Programs and Features to see which version you have that way it doesn't matter what browser you have or if you have some add-on that blocks changes to the user agent string.
Post #1102141
Posted Tuesday, May 3, 2011 4:33 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 4:46 AM
Points: 5,439, Visits: 1,400
Nice one....


Post #1102213
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse