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 ««12345»»»

Installing SQL Server 2005 Expand / Collapse
Author
Message
Posted Friday, July 29, 2011 4:05 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 4:28 AM
Points: 1,248, Visits: 779
Ah! an assumption... he he! not so clear then

_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1150767
Posted Friday, July 29, 2011 5:23 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen 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
Posted Friday, July 29, 2011 5:30 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, September 12, 2014 8:51 AM
Points: 1,823, Visits: 902
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
Posted Friday, July 29, 2011 5:43 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:30 AM
Points: 1,422, Visits: 1,838
Thank-you for the question. It is good to know that such a bug ever existed with SQL Server.

Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Post #1150834
Posted Friday, July 29, 2011 6:18 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
Went for the obvious answer of installs correctly given the information provided.

http://brittcluff.blogspot.com/
Post #1150854
Posted Friday, July 29, 2011 6:39 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 17, 2014 4:56 AM
Points: 1,002, Visits: 884
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
Posted Friday, July 29, 2011 7:03 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 8, 2014 6:15 PM
Points: 2,278, Visits: 3,793
It would be nice to have more questions like these. Good question. Thanks.

Mohammed Moinudheen
Post #1150889
Posted Friday, July 29, 2011 7:07 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, September 12, 2014 8:38 AM
Points: 3,675, Visits: 72,434
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
Posted Friday, July 29, 2011 7:08 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, September 12, 2014 8:38 AM
Points: 3,675, Visits: 72,434
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
Posted Friday, July 29, 2011 7:09 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, September 12, 2014 8:38 AM
Points: 3,675, Visits: 72,434
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


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 »

Add to briefcase ««12345»»»

Permissions Expand / Collapse