Amazon ec2 running windows and sql server

Another great use: testing software. The whole reason I wrote this article today was that I had to test a new beta of Quest Change Director, and I needed a quick new environment to test it in. Everybody wins. EC2 comes in as a neat solution when you need to quickly spin up multiple machines to test mirroring failovers, test log shipping, test vendor products without blowing away your machine and reinstalling, etc — but you pay for that convenience.

How about persistance? Can I use my sql server instance for production? Can I keep it running all the time? What if it crashes, do I lose all my data? Emad — yep, you can use it for production. Thanks a lot for the comprehensive and easy to follow instructions. I got stuck at getting the Administrator password. You mention in your article that it eventually works after couple tries.

It never did for me. Is there any workaround that you have found for that issue? No, I haven't, but Amazon has added a new management console that may suit your needs better than the Firefox plugin. You have to put your fully qualified domain name for your instance. You can save it on a file sharing service like drop. I am new to EC2 and figuring things our how to setup my servers. I am using SQL Server on windows server I am an ASP. For backup instead of doing log shipping and storing transaction logs I am thinking to have a differnt solution which can work like Full backup.

I think to have 5 snapshots of my EBS database through out the day. Snapshots older than 2 days will be deleted. In this case all snapshot will have Fullbackup for last 2 days as those are going to be exact same copy of EBS volume. It depends on the size of your database and how critical it is. How does the database persist in the case of an instance crash? That all seemed to work fine, however restarting the instance and re-connecting the ESB was a bit clumsy and I kept feeling like I was doing it wrong.

You might try checking the EC2 forums at Amazon though. I an able to login the remote server.. Thanks for this nice and detailed description. How can we configure that? I already added the port to the firewall settings.

Also, any ideas how to setup hamachi in EC2? Hi, I am looking to experiment with SQL failover clustering. Do you think it will be cost effective to set up on Amazon EC2? I want to practise the exercises in the MS book exam chapter Here is the requirements:.

Before You Begin To complete the lessons in this chapter, you must have???? Cluster-capable hardware or Microsoft Virtual Server R2???? You use Virtual Server for all the practices in this chapter. To follow the steps in the practices, The practices in the lessons require you to have performed the following actions:???? Created three virtual machines????

Installed Windows Server Standard edition and later or Windows Server Standard edition and later onto each virtual machine???? Configured one virtual machine as a domain controller???? Configured two virtual machines as member servers in the domain???? Configured the domain controller with a single network adapter, as shown in Table ???? Configured the member servers with two network adapters, as shown in Table ????

Configured all networks as Guest Only. Hi, Arnold. Sounds great to me. What about security to the machine. Would you change to a non-standard port and then force ssl connections?

What else could be done? Sam — thanks! Amazon has a VPN product so you can bridge to your own datacenter. I was also wondering about what type of storage would be used, but EC2 docs say that W is default to EBS, giving you persistent storage.

VPN is a extra charge of. Looks great for SAN meltdowns! Could you please let me know How to restore full sql server database to amazon EC2? I have a. How can I move it on EC2 and restore it? How can i configure backup on s3? How can recover it from s3? If any one have reference link then please share it.

Your best bet for EC2-related questions will be Books Online. This announcement may be partly in response to Microsoft who has been building a hosted development platform of their own. Today, you can choose from a variety of Unix-based operating systems, and soon you will be able to configure your instances to run the Windows Server operating system.

NET web sites, high performance computing clusters, and other Windows-based applications. Amazon said, "By choosing Amazon EC2 as the deployment environment for your Windows-based applications, you will be able to take advantage of Amazon's proven scalability and reliability, as well as the cost-effective, pay-as-you-go pricing model offered by Amazon Web Services.

The ability to run a Windows environment within Amazon EC2 has been one of our most requested features, and we are excited to be able to provide this capability. Subscribe to Blog via RSS.