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 Thursday, July 28, 2011 9:40 PM


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: 2 days ago @ 2:22 PM
Points: 3,466, Visits: 1,819
Comments posted to this topic are about the item Installing SQL Server 2005

Kenneth Fisher
I 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
Post #1150652
Posted Thursday, July 28, 2011 9:44 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 9, 2014 11:11 PM
Points: 2,057, Visits: 243
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.
Post #1150653
Posted Friday, July 29, 2011 2:27 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 19, 2014 2:44 AM
Points: 549, Visits: 1,016
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.
Post #1150715
Posted Friday, July 29, 2011 2:35 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, October 13, 2014 6:42 AM
Points: 5,216, Visits: 5,111
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
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

Post #1150718
Posted Friday, July 29, 2011 3:15 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
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


_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1150739
Posted Friday, July 29, 2011 3:31 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 19, 2014 2:44 AM
Points: 549, Visits: 1,016
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.
Post #1150744
Posted Friday, July 29, 2011 3:35 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
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.
Post #1150748
Posted Friday, July 29, 2011 3:57 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 5:54 AM
Points: 868, Visits: 1,141
SQL can't be installed on a single socket machine?

Carlton.
Post #1150761
Posted Friday, July 29, 2011 4:00 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
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...


_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1150763
Posted Friday, July 29, 2011 4:02 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 19, 2014 2:44 AM
Points: 549, Visits: 1,016
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
Post #1150765
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse