Installing SQL 2008 / VS2008 / Crystal Reports on EC2

Gravity Jack In the Press

Installing SQL 2008, Visual Studio 2008 and Crystal Reports ALL on Amazon EC2
Aaron Lennon – CTO, Gravity Jack

I noticed many postings on Amazon.com complaining about the 10 GB limited for AMI’s and how this prevented the installation of critical development components. I like the idea of Amazon keeping their AMI images as small as possible.
I will say it is not “simple” but there is a way to get the job done without having to perform any strange hacks that allow other drives to be seen as part of the system drive.
1) Start your windows AMI.
a. Any of the free default AMI’s that Amazon offers will do.
2) Create an EBS volume and attach it to your windows instance and attach it to your instance.
a. If you need help attaching the EBS volume then follow these instructions.
b. If you are hosting development environments on Amazon like I am it is good to checkout your Subversion repositories and host all SQL Server database files (.MDF .LDF) on an EBS volume for a fast and simple backup measure.
c. Make your EBS Volume 100GB or larger. I used 10GB for this example but there is no point to a 10GB EBS volume.
3) Install VS 2008
a. Select the options you want. I installed all languages because we host our development servers on Amazon and it is nice to be able to open a project in Visual Studio on the server is something is not working correctly after deployment. I also installed with Crystal Reports. The only options I didn’t install are a number of development tools for mobile applications and VSTO (Visual Studio Tools for Microsoft Office).
4) Install VS 2008 Service Pack
a. Now, assuming you have enough free space left install the Visual Studio 2008 service packs. These service packs don’t really take up much space at all but will fail to install if you don’t have a little over 3 gig free. If the installation does fail due to lack of free space then just install it again after the next step
5) Delete the following files to free a lot of space or move them to the D drive.
a. $NTServicePackUninstall* and $NtUninstallKB*
b. C:WINDOWSSoftwareDistributionDownload
6) Install SQL Server 2008 and customize the installation so the databases are stored to the EBS volume you created in step 2.
7) Did it work? Check to be sure everything is working and clear your browser cache and uninstall any unneeded programs etc.
a. If everything went well you should still have over 2 GB of free space.
8) Bundle your new perfectly configured windows instance. (You don’t want to lose all the work you have done)
a. This is done easily from your AWS control panel. Just right click on your instance and choose Bundle Instance.
b. After you complete the bundle process you are able to start new Servers easily and the configurations can be replicated with a single click.
9) Take a Snapshot of your EBS Volume. (You don’t want to lose all the work you have done)
a. This is also easily done from your AWS Control Panel. Just right click on your EBS Volume and choose to make a Snapshot.
b. A new snapshot should be taken on regular intervals so you always have a good backup of your EBS volume.
If you have any questions about Amazon EC2 support for your applications, please contact me. I am happy to help.

lling SQL 2008 and VS2008 and Crystal Reports ALL on Amazon EC2.

I noticed many postings on Amazon.com complaining about the 10 GB limited for AMI’s and how this prevented the installation of critical development components.  I like the idea of Amazon keeping their AMI images as small as possible.

I will say it is not “simple” but there is a way to get the job done without having to perform any strange hacks that allow other drives to be seen as part of the system drive.

1) Start your windows AMI.

a. Any of the free default AMI’s that Amazon offers will do.

2) Create an EBS volume and attach it to your windows instance and attach it to your instance.

a. If you need help attaching the EBS volume then follow these instructions.

b. If you are hosting development environments on Amazon like I am it is good to checkout your Subversion repositories and host all SQL Server database files (.MDF .LDF) on an EBS volume for a fast and simple backup measure.

c. Make your EBS Volume 100GB or larger.  I used 10GB for this example but there is no point to a 10GB EBS volume.

3) Install VS 2008

a. Select the options you want. I installed all languages because we host our development servers on Amazon and it is nice to be able to open a project in Visual Studio on the server is something is not working correctly after deployment. I also installed with Crystal Reports.  The only options I didn’t install are a number of development tools for mobile applications and VSTO (Visual Studio Tools for Microsoft Office).

4) Install VS 2008 Service Pack

a. Now, assuming you have enough free space left install the Visual Studio 2008 service packs.  These service packs don’t really take up much space at all but will fail to install if you don’t have a little over 3 gig free.  If the installation does fail due to lack of free space then just install it again after the next step J

5) Delete the following files to free a lot of space or move them to the D drive.

a. $NTServicePackUninstall*  and $NtUninstallKB*

b. C:WINDOWSSoftwareDistributionDownload

6) Install SQL Server 2008 and customize the installation so the databases are stored to the EBS volume you created in step 2.

7) Did it work?  Check to be sure everything is working and clear your browser cache and uninstall any unneeded programs etc.

a. If everything went well you should still have over 2 GB of free space.

8) Bundle your new perfectly configured windows instance. (You don’t want to lose all the work you have done)

a. This is done easily from your AWS control panel. Just right click on your instance and choose Bundle Instance.

b. After you complete the bundle process you are able to start new Servers easily and the configurations can be replicated with a single click.

9) Take a Snapshot of your EBS Volume. (You don’t want to lose all the work you have done)

a. This is also easily done from your AWS Control Panel.  Just right click on your EBS Volume and choose to make a Snapshot.

b. A new snapshot should be taken on regular intervals so you always have a good backup of your EBS volume.

If you have any questions about Amazon EC2 support for your applications, please contact me. I am always happy to help.

Screenshot of final server instance contents is below.

Aaron Lennon

CTO

alennon@gravityjack.comhttps://gravityjack.com/Office (877) 691-3048
yahoo= aaron_at_gravityjack
skype = aaron_at_gravityjack
msn = alennon@gravityjack.com
ICQ = 290619095

We build your vision, your software, your future, and most importantly your trust

RELATED ARTICLES

  • Crafting Personalized Retail Expereinces With Augmented Reality

    Augmented Reality: Revolutionizing Retail Customization

    In the bustling realm of retail, Augmented Reality (AR) is ushering in an era where shopping becomes a personalized showcase. Imagine trying on clothes without stepping into a dressing room, or placing furniture in your living room with just a tap on your screen. With an anticipated market growth to USD 795.3 billion by 2025, it’s clear that consumers crave these cutting-edge experiences.

    • AR empowers consumers to customize products in real-time.
    • Big names like IKEA, Sephora, and Nike are pioneering this space.
    • Insightful data gleaned from AR interactions are redefining marketing strategies.

    At Gravity Jack, we’re not just observers but active innovators in AR development. We provide immersive solutions that resonate with consumers, paving the way for businesses to weave their narratives into the customer’s world. Dive into our blog to see how the tactile future of digital shopping is already at our fingertips.

  • Augmented Reality: A Guide to Understanding Its Impact on Business, Products, and Branding

    Dive into the expanding universe of Augmented Reality (AR) with Gravity Jack’s latest insights on creating captivating AR applications. As the industry projects a staggering growth, hitting a market value of $3664.5 million by 2025, we’re here delivering the golden rules and innovative solutions for AR success.

    • User-Centered Design: Just like Snap Inc. and Niantic have aced user feedback, we craft AR experiences with your audience as our north star.

    • Technical Mastery: Conquer challenges like real-time tracking and cross-platform compatibility with our expertise inspired by ARCore and ARKit.

    • Next-Gen Immersion: Get excited about optimizing AR for the freshest platforms like the Apple Vision Pro and Oculus Quest 3; we’re all about that realistic occlusion and silky-smooth refresh rate.

    Stay ahead in the AR game with a partner who marries professional finesse with a playful edge. For a sneak peek at the future tailored by hands-on creativity, peruse our full article on AR Application Development Best Practices. Discover more and let the magic of AR enhance your digital landscape.

  • Navigating the Future: Augmented Reality in Navigation and Wayfinding

    Dive into the dynamic domain of AR in navigation and wayfinding with Gravity Jack, where we lead the integration of digital landscapes right into the fabric of your reality. Here’s a glimpse:
    – Enlightening statistics reveal a market on the rise, projecting vast expansions by 2026.
    – Discover how AR navigation tools like Google’s “Live View” transform pedestrian travel.
    Indoor spaces become vividly mapped playgrounds, reducing the dread of getting lost.
    – Watch location-based AR experiences convert everyday navigation into an adventure.
    – Across transportation, tourism, and urban planning, AR is sculpting a smarter world.

    Join us as we outline our vital contributions in this rapidly evolving sector, where experience meets innovation. Ready to unravel the impact of AR with a touch of charm? Jump into our professional yet playful exploration for a read that promises novelty at every turn! 🌐✨