SQL Server 2008 Installation Issues - Issues and Workarounds

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Robert Pearl » SQL Server 2008 Installation Issues - Issues...

SQL Server 2008 Installation Issues - Issues and Workarounds

Rate Topic

Display Mode

Topic Options

Author

Message

RSP

Posted Thursday, April 28, 2011 12:01 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 30, 2013 8:44 AM
Points: 172, Visits: 479

Comments posted to this topic are about the item SQL Server 2008 Installation Issues - Issues and Workarounds

Post #1099993

econwatch

Posted Thursday, April 28, 2011 7:27 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 02, 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

RSP

Posted Thursday, April 28, 2011 7:43 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 30, 2013 8:44 AM
Points: 172, Visits: 479

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

aureolin

Posted Thursday, April 28, 2011 12:17 PM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, June 10, 2013 10:30 AM
Points: 494, Visits: 947

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'. BigGrin

Steve G.

Post #1100463

econwatch

Posted Thursday, April 28, 2011 12:38 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 02, 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

aureolin

Posted Thursday, April 28, 2011 12:57 PM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, June 10, 2013 10:30 AM
Points: 494, Visits: 947

Hey, that works! Cool!

Post #1100503

smartin108

Posted Friday, April 29, 2011 8:22 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, March 09, 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

peter.row

Posted Tuesday, May 03, 2011 1:06 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 1:18 AM
Points: 180, Visits: 212

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

peter.row

Posted Tuesday, May 03, 2011 1:09 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 1:18 AM
Points: 180, Visits: 212

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

Anipaul

Posted Tuesday, May 03, 2011 4:33 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:01 AM
Points: 4,816, Visits: 1,343

Nice one....

Post #1102213

« Prev Topic | Next Topic »

Permissions