Installing SQL Server 2005

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 Kenneth Fisher » Installing SQL Server 2005

49 posts, Page 2 of 5

««1 2 3 4 5 »»»

Installing SQL Server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

DugyC

Posted Friday, July 29, 2011 4:05 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 1:19 AM
Points: 1,181, Visits: 744

Ah! an assumption... he he! not so clear then Wink

_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"

Post #1150767

cengland0

Posted Friday, July 29, 2011 5:23 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299

Carlton Leach (7/29/2011)

SQL can't be installed on a single socket machine?

Carlton.

It can. One is a power of two (2^0).
According to the reference:

The ratio between logical processors and physical sockets is not a power of 2. For example, the computer has a single socket together with a triple-core processor.

Besides, the problem was fixed in SP2.

Post #1150817

Rich Weissler

Posted Friday, July 29, 2011 5:30 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 6:26 AM
Points: 1,581, Visits: 795

I figured the question came up because of a real life problem - and therefore assumed it probably DIDN'T install correctly... but I still picked that answer assuming I'd learn something new this morning. Thank you for the information and link!

I think the question was fair. Good job.

Post #1150824

Nakul Vachhrajani

Posted Friday, July 29, 2011 5:43 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, June 10, 2013 6:56 AM
Points: 1,282, Visits: 1,613

Thank-you for the question. It is good to know that such a bug ever existed with SQL Server.

Thanks & Regards,
Nakul Vachhrajani.
http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.

Follow me on
Twitter: @nakulv_sql
Google Plus: +Nakul

Post #1150834

Britt Cluff

Posted Friday, July 29, 2011 6:18 AM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, October 24, 2012 8:17 PM
Points: 1,588, Visits: 247

Went for the obvious answer of installs correctly given the information provided.

http://brittcluff.blogspot.com/

Post #1150854

GregoryF

Posted Friday, July 29, 2011 6:39 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, June 10, 2013 8:14 AM
Points: 961, Visits: 797

This has bit me numerous times (including last week), now I make a habbit of changing the boot.ini file to one processor before all SQL 2005 installs on machine with an odd number of total processors or cores. That being said, one processor is an odd number, yet the install works

/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

Post #1150868

mohammed moinudheen

Posted Friday, July 29, 2011 7:03 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:29 PM
Points: 2,178, Visits: 3,599

It would be nice to have more questions like these. Good question. Thanks.

Mohammed Moinudheen

Post #1150889

mtassin

Posted Friday, July 29, 2011 7:07 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 9:09 PM
Points: 3,250, Visits: 65,525

anthony.green (7/29/2011)

I would have to agree with Murray on this, it would have been nice to know which level of the product it relates to.

All the media I have been working with included SP2 as part of the disk so I have never encountered this issue.

Same here. Stating RTM SQL 2005 or SP1 2005 would have clarified it better. Alas...

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems

Post #1150897

mtassin

Posted Friday, July 29, 2011 7:08 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 9:09 PM
Points: 3,250, Visits: 65,525

Shark Energy (7/29/2011)

No excuses people I mean if follow the question in your head, it fails before you get to installing any SPx so follow the question and its all in front of you.

Not if you or a helpful netadmin slipstreamed the sp onto the RTM install media, or the disk you purchased to install came with SP2.

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems

Post #1150899

mtassin

Posted Friday, July 29, 2011 7:09 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 9:09 PM
Points: 3,250, Visits: 65,525

Shark Energy (7/29/2011)

In the absence of an SP listed in the question for the SQL install, I'd assume he is referring to vanilla flavour.

Totally agreeing to disagree Tongue

You can't assume RTM anymore than a specific SP as he didn't specify RTM either.

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems

Post #1150902

« Prev Topic | Next Topic »

49 posts, Page 2 of 5

««1 2 3 4 5 »»»

Permissions