SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2008 Installation Issues - Issues and Workarounds


SQL Server 2008 Installation Issues - Issues and Workarounds

Author
Message
RSP
RSP
Mr or Mrs. 500
Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)

Group: General Forum Members
Points: 546 Visits: 623
Comments posted to this topic are about the item SQL Server 2008 Installation Issues - Issues and Workarounds



econwatch
econwatch
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 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}
RSP
RSP
Mr or Mrs. 500
Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)

Group: General Forum Members
Points: 546 Visits: 623
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



aureolin
aureolin
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1077 Visits: 1056
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'. :-D

Steve G.



econwatch
econwatch
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 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.
aureolin
aureolin
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1077 Visits: 1056
Hey, that works! Cool!



smartin108
smartin108
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 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.
peter.row
peter.row
SSC Eights!
SSC Eights! (969 reputation)SSC Eights! (969 reputation)SSC Eights! (969 reputation)SSC Eights! (969 reputation)SSC Eights! (969 reputation)SSC Eights! (969 reputation)SSC Eights! (969 reputation)SSC Eights! (969 reputation)

Group: General Forum Members
Points: 969 Visits: 448
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.
peter.row
peter.row
SSC Eights!
SSC Eights! (969 reputation)SSC Eights! (969 reputation)SSC Eights! (969 reputation)SSC Eights! (969 reputation)SSC Eights! (969 reputation)SSC Eights! (969 reputation)SSC Eights! (969 reputation)SSC Eights! (969 reputation)

Group: General Forum Members
Points: 969 Visits: 448
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.
Anipaul
Anipaul
SSCrazy Eights
SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)

Group: General Forum Members
Points: 9851 Visits: 1407
Nice one....



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search