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 12»»

Error installing MS SQL Server R2 Enterprise (x64) Expand / Collapse
Author
Message
Posted Wednesday, April 23, 2014 1:38 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 2:31 PM
Points: 59, Visits: 123
Hi Everyone,

Recently I attempted to upgrade from MS SQL Server to MS SQL Server R2.

However I have encountered an error, as shown in the link below:

Summary_Home-PC_20140417_191232.txt

If anybody can offer any help here it will be greatly appreciated.

Kind Regards,

Davo
Post #1564122
Posted Wednesday, April 23, 2014 4:31 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 9:22 AM
Points: 216, Visits: 1,372
I'm guessing as you haven't given much info, but presume you're trying to install Enterprise edition on Windows 7 OS...

installing-sql-server-2008-r2-enterprise-on-windows-7


and...

Hardware and Software Requirements for Installing SQL Server 2008 R2


Edit: added MS SQL Server link
Post #1564190
Posted Wednesday, April 23, 2014 5:08 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:50 AM
Points: 6,641, Visits: 14,225
please provide futher info from this file

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140417_191232\Detail.txt


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1564202
Posted Wednesday, April 23, 2014 7:20 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 9:22 AM
Points: 216, Visits: 1,372
Think you'll find these are the key bits in the error txt file...


Machine Properties:
Machine name: HOME-PC
Machine processor count: 8
OS version: Windows 7
OS service pack: Service Pack 1
...
Package properties:
Description: SQL Server Database Services 2008 R2
ProductName: SQL Server 2008 R2
Type: RTM
...
Installation edition: ENTERPRISE
...


I don't believe you can install or upgrade SQL Server 2008 R2 Enterprise Ed. on WIndows 7...unless someone can correct me on this


Edit: Hex colour setting didn't work, so have removed them.
Post #1564254
Posted Wednesday, April 23, 2014 5:55 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 2:31 PM
Points: 59, Visits: 123
Hi Everyone,

Thank you for your interest in my post; here is the additional information that I have been asked to supply -

Details.txt

Any further assistance will be greatly appreciated.

Kind Regards,

Davo
Post #1564480
Posted Thursday, April 24, 2014 12:39 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 2:31 PM
Points: 59, Visits: 123
Hi Everyone,

I managed to install MS SQL Server 2008 R2 Enterprise into Windows 7 by following the steps below -

1). Added my Windows Account to 'Debug Programs'

Start | Run | Type: gpedit.msc | OK | Navigate to Computer Configuration\Windows Settings\Security Settings\Local Policies\User Rights Assignment\Debug programs

2). Uninstalled every trace of anything and everything with the program name MS SQL... using CCleaner.

3). Cleaned the registry using CCleaner

4). Installed MS SQL Server R2 2008 using the excellent YouTube video instructions linked below -

Installing SQL Server R2 2008 in windows 7

As a side note I also used a script to enable the MS SQL Ports, it is available here.

I would like to thank everybody again for all of the help that I have received with my post.

Kind Regards,

Davo
Post #1564547
Posted Thursday, April 24, 2014 2:52 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 9:22 AM
Points: 216, Visits: 1,372
OK, I'm confused here. The yt vid shows the person installing SQL 2008 R2 Developer ed, which is possible as Developer ed can be installed on a wide variety of OS types (Server and Client OSs).

So, david.dartnell, have you managed to install SQL 2008 R2 Enterprise ed on your PC running Windows 7?

I know you mention it, above, but I'm really interested to confirm this is Enterprise ed and not Developer ed.


Edit: changed mention of Hardware to mention of OS types.
Post #1564584
Posted Friday, April 25, 2014 9:11 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 9:22 AM
Points: 216, Visits: 1,372
Hi David,

I was hoping you would come back on this and confirm if you managed to install the SQL2008 R2 Enterprise Database Engine on your Windows 7 OS-based PC.

If this was not the engine, then was it just the SQL Server Management Studio (SSMS) tools, etc.?

I would be interested to know if this is the case as Microsoft say that SQL2008 R2 Enterpise Ed should not install on a client-based OS, such as Windows 7.

Thanks
Post #1565135
Posted Sunday, April 27, 2014 9:38 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 2:31 PM
Points: 59, Visits: 123
Yes, definitely the Enterprise Edition (x64)! I am a part time student and got my hands on the EE through Microsoft DreamSpark. I wanted to make sure that I was using the most feature rich version of the software, and I didn't want to go to the hassle of installing a Server OS.
Post #1565441
Posted Wednesday, April 30, 2014 4:30 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 9:22 AM
Points: 216, Visits: 1,372
david.dartnell (4/27/2014)
Yes, definitely the Enterprise Edition (x64)! I am a part time student and got my hands on the EE through Microsoft DreamSpark. I wanted to make sure that I was using the most feature rich version of the software, and I didn't want to go to the hassle of installing a Server OS.


Thx for coming back, though not sure your answer has helped as you didn't confirm you installed the SQL Engine, and not just the SQL Server Management Tools. Also, when I look on DreamSpark, I just see SQL2008 R2 Developer ed available...




Just of note, Developer edition is a full feature-rich version, ie, its Enterprise ed but with a different licencing requirement and has been set so that it will load onto Client OS's as well as Server OS's. Apart for the OS thing, Developer ed is to all intents and purposes, Enterprise ed.

thx
Post #1566292
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse