We have an Amazon EC2 box running the Windows Server 2008 with MS SQL Server 2008 R2. The default instance of the SQL server is running fine (the default MSSQLSERVER), we want to add a second one – when we go to the the set up and configuration (the SQL Server Installation Center) it asks for Installation Media folder.
Does anyone know if we can get it (or if we can)? We have tried looking for drives to mount that possibly had the installation on, but no luck.
Best Answer
It looks like the ability to create multiple instances is not included with the licensing provided by Amazon/Microsoft when using the SQL Server EC2 instance type. I went through the list of public snapshots on US-EAST, and there's no public media snapshot available for SQL Server (there is for the operating system discs, though.)
Another person asked about this on their support site, but Amazon didn't respond to the post and the conclusion was that it wasn't available.
If you have access to a physical (or the files contained on a) SQL Server 2008 R2 disc, you could upload it yourself (there's currently no charge for inbound bandwidth to AWS). This may be a violation of the software license, though. You'd have to ask Amazon about that (but you may not get an answer without their Premium Support package.)