Tips to Install SQL Server 2005 Standard with everything in it

  • It's been a while since i've installed a new instance of SQL Server 2005 with all the trimmings so i was looking for some simple steps to follow for the installation.

    I currently have a full working version of SQL Server 2005 Standard Edition SP3 on my LIVE server which i want to replicate on my laptop for development purposes.

    This instance will be installed from scratch and will need all the trimmings such as:

    - SQL Server 2005 Standard SP3 (SSMS included of course)

    - Integration Services (including BIDS for SSIS package development)

    - Reporting Services

    - Analysis Services

    I recall the installation disks basically walk me through a custom installation where i can select all options i want.

    Is there any other steps i should follow, including SP upgrades, etc...?

  • Thanks for the link. I hadn't thought about video. Maybe youtube also has some helpful tutes.

    Also, do you think i should install the instance name exactly the same as the one on my LIVE server? Or should i just name it something new?

    Remember this will be for development purposes, however i also plan on installing Visual Web Developer 2008 along with SQL Server 2008 express as well. Hopefully this won't cause any issues?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply