Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
SQL 2005 MCTIP Certification RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hello,

    I need some help in preparing for thje 70-431 exams. After buying the books and the study materials, I realised that you need to be running Windows 2003 server or XP professional on my home PC. 
    The problem I have is I use an XP home edition PC and unfortunately I could create a partion on my PC so that I can have multiple OS . Does anybody have any idea what I can do to install SQL 2005 for my studies. 

    Also which is the best certification to go for is the MCTIP Database Administrator or Developer.  

    Thanks in advance for your help
    Saturday, July 5, 2008 1:15 AM

Answers

  • Question
    Sign in to vote
    2
    Sign in to vote
    I would look at Virtual PC 2007. While Windows XP Home Edition isn't officially supported it will install. The installation wizzard will whine that your OS isn't supported but also offers a nice check box to not remind you of that fact anymore and the installation will continue.

    Once you've installed it I'd download the Virtual Server running SQL 2005 from Microsoft Technet which is located here:
    http://www.microsoft.com/downloads/details.aspx?FamilyID=7b243252-acb7-451b-822b-df639443aeaf&DisplayLang=en

    Granted you will want as much ram as your OS/Hardware will allow.

    For a complete list of available pre-configured VHD downloads go here:
    http://www.microsoft.com/downloads/results.aspx?pocId=&freetext=msvhds&DisplayLang=en

    Good Luck.


    Stephen Charles Rea [MCT] askthemct.com
    • Marked as answer by .revEditor Saturday, July 5, 2008 5:59 PM
    • Unmarked as answer by Obalekans Tuesday, July 8, 2008 11:24 PM
    • Marked as answer by .revEditor Wednesday, July 16, 2008 11:18 AM
    Saturday, July 5, 2008 5:59 PM
    Answerer
  • Question
    Sign in to vote
    1
    Sign in to vote
    The developer edition is the same with the Enterprise edition with no deployment restrictions so you can use it for your study but just know reporting services will be disabled by default because you don't have IIS running because it does not come with XP home.  But you still need to upgrade your operating system because I think after exam 70-431 you may need some of the features in XP pro or a server. 

    If you decide to upgrade to Vista you need at least Vista Ultimate or Vista Business because all other IIS 7 does not come with Windows authentication needed for Reporting Services.  This last part is just for your information because Reporting services is only needed for the BI exams.  So start with the trial edition and spend time with Management Studio and run searches in the BOL(books online) for Management Studio based configurations of most database Admin Tasks.

    http://www.microsoft.com/sql/editions/developer/sysreqs.mspx

    Asp.net MVP, MCPD Web C#, MCITP BI & MCTS SQL Server 2005
    • Marked as answer by .revEditor Saturday, July 5, 2008 8:44 PM
    Saturday, July 5, 2008 1:59 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote
    Home editions were not designed with virtualization in mind, so Virtual PC is out. Can you upgrade this PC to Professional?

    As to your second question; what is it you want to do: Develop or Administer? Or both? Who cares which one we think is best. The only person who knows what is best for you is YOU. Whatever technology you have profiencey in is the best one for you.

    Michael D. Alligood, MCITP, MCTS, MCSA, MCDST, MCP, A+, Network+ www.theitclassroom.com
    Saturday, July 5, 2008 1:40 AM
  • Question
    Sign in to vote
    1
    Sign in to vote
    The developer edition is the same with the Enterprise edition with no deployment restrictions so you can use it for your study but just know reporting services will be disabled by default because you don't have IIS running because it does not come with XP home.  But you still need to upgrade your operating system because I think after exam 70-431 you may need some of the features in XP pro or a server. 

    If you decide to upgrade to Vista you need at least Vista Ultimate or Vista Business because all other IIS 7 does not come with Windows authentication needed for Reporting Services.  This last part is just for your information because Reporting services is only needed for the BI exams.  So start with the trial edition and spend time with Management Studio and run searches in the BOL(books online) for Management Studio based configurations of most database Admin Tasks.

    http://www.microsoft.com/sql/editions/developer/sysreqs.mspx

    Asp.net MVP, MCPD Web C#, MCITP BI & MCTS SQL Server 2005
    • Marked as answer by .revEditor Saturday, July 5, 2008 8:44 PM
    Saturday, July 5, 2008 1:59 AM
  • Question
    Sign in to vote
    2
    Sign in to vote
    I would look at Virtual PC 2007. While Windows XP Home Edition isn't officially supported it will install. The installation wizzard will whine that your OS isn't supported but also offers a nice check box to not remind you of that fact anymore and the installation will continue.

    Once you've installed it I'd download the Virtual Server running SQL 2005 from Microsoft Technet which is located here:
    http://www.microsoft.com/downloads/details.aspx?FamilyID=7b243252-acb7-451b-822b-df639443aeaf&DisplayLang=en

    Granted you will want as much ram as your OS/Hardware will allow.

    For a complete list of available pre-configured VHD downloads go here:
    http://www.microsoft.com/downloads/results.aspx?pocId=&freetext=msvhds&DisplayLang=en

    Good Luck.


    Stephen Charles Rea [MCT] askthemct.com
    • Marked as answer by .revEditor Saturday, July 5, 2008 5:59 PM
    • Unmarked as answer by Obalekans Tuesday, July 8, 2008 11:24 PM
    • Marked as answer by .revEditor Wednesday, July 16, 2008 11:18 AM
    Saturday, July 5, 2008 5:59 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote
    Stephen, why are you removing all my proposed answers and marking yours as answers. You have done this numerous times now. You have removed my proposed answers, and they have been marked again by other users and then you mark them as answers.

    Many times you are just saying the same thing as I am. In one instance you marked your single post as answered 3x! (see http://forums.community.microsoft.com/en-US/CertGeneral/thread/54574781-deb5-48cb-9ca1-0a08e770ff3c/)

    It doesn't really much matter to me as long as the posters are getting their questions answered. It just seems like an abuse of moderating privileges to me by inflating your own points.  
    Michael D. Alligood, MCITP, MCTS, MCSA, MCDST, MCP, A+, Network+ www.theitclassroom.com
    Saturday, July 5, 2008 7:06 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks Micheal
    Tuesday, July 8, 2008 10:54 PM