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


Installing SQL Server 2005


Installing SQL Server 2005

Author
Message
Kenneth Fisher
Kenneth Fisher
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6209 Visits: 2059
Comments posted to this topic are about the item Installing SQL Server 2005

Kenneth FisherI strive to live in a world where a chicken can cross the road without being questioned about its motives.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/Link to my Blog Post --> www.SQLStudies.com
murray-906152
murray-906152
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3049 Visits: 287
I think it would have been fairer to point out what SP version of SQL Server 2005 the question related to.

Given one tries to keep SQL Server updated are far as practical, just stating SQL Server 2005 does not imply there is a particular issue with an old SP version.

Regards, Murray.
Shark Energy
Shark Energy
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1787 Visits: 1018
Murray, surely that wouldn't make a difference to the question as it states you are doing the default install with default options - no SP.

I got it right but took a chance as I felt like it was a trick question as, as far as I know, a single processor install works fine and that is an odd number too.
anthony.green
anthony.green
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23538 Visits: 6519
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.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


DugyC
DugyC
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1684 Visits: 779
I don't mind so much getting this one wrong, as I have learnt a lot along the way, and had a very interesting time trying to find the answer.

However, I do 100% fully consider this a trick question. Why? Because the author specifies the Service Pack when it comes to Windows Server, but omits it for SQL Server, which leaves you wondering therefore what is the correct answer, as it is very much SP specific. The default scenario would be to always maintain your servers with the latest SP, and therefore you would have at least SP2 (most likely SP3, maybe even SP4) on this SQL Server 2005 installation.

However, this question was about a previous (to current) version of SQL Server on a specific version of the SP, and the author deliberately omitted to specify that in the question.

That aside, a great question which, as I say, I had a great time researching. Thanks :-D

_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Shark Energy
Shark Energy
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1787 Visits: 1018
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.
cengland0
cengland0
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2220 Visits: 1300
Got it right by process of elimination. The installs correctly almost had me but that would have been too easy. Obviously there was something that was going to go wrong. I knew the other two fail options weren't correct so it had to be the odd number of processors as the only correct answer.

Besides, that's weird to have an odd number of processors installed in a server. Personally, I've never seen that before but that doesn't make it impossible.
Carlton Leach
Carlton Leach
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1544 Visits: 1304
SQL can't be installed on a single socket machine?

Carlton.
DugyC
DugyC
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1684 Visits: 779
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 the disc you installed it from is already with SP2 or 3... and there are plenty of those around, or for that matter if you downloaded it from an MSDN subscription with SP2 of 3.

Agree to disagree me thinks... :-P

_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Shark Energy
Shark Energy
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1787 Visits: 1018
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 :-P
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