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
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

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

Kenneth Fisher
I was once offered a wizards hat but it got in the way of my dunce cap.
--------------------------------------------------------------------------------
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 (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3278 Visits: 288
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
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4411 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 Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

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



How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


DugyC
DugyC
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2276 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
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4411 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
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3304 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
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

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

Carlton.
DugyC
DugyC
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2276 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
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4411 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