Installing Dynamics CRM2011 Amazon Relational Database Services (RDS) – Part 1

I have been working with Amazon RDS for some time and always wondered that can we install CRM using Amazon RDS? This was a question haunting my mind for from the moment I have started exploring the features of RDS.
After setting up my AWS account I wanted to try this so bad and I did it. The main reason for going with RDS is the rich set of features provided by RDS. You can read more about these feature on the following link. Amazon Relational Database Services-Features

So I have set up an EC2 instance as bellow. Then I configured it to install CRM2011, i.e. configuring IIS and Active Directory services.
Image3

Then I have set up a RDS instance as bellow.

Image10

Make sure that the security group for the EC2 instance and the RDS instance is the same; otherwise you can’t access the RDS instance from the EC2 instance. At the present, it doesn’t support SQL server Analysis and Integration service as well.

Image11

After setting up the instances I have started the deployment of CRM2011, but it failed, because the RDS is not supporting SQL Server Reporting Services.
So I have found a workaround for this. After searching for some time I came across the following link to launch Optimized SQL server instance published by Microsoft. Microsoft optimized instance for SQL Server 2008 R2

So when we design the CRM2011 deployment I assume that we could use this particular image as a separate server which is running SSRS and point to RDS instance as the database. This solution will enhance the performance of the CRM Reports as the SSRS are running with dedicated resources. Or else we could use this as the backend SQL server for the EC2 instance. I’m going to explore these solutions in Part of this blog post.

Advertisements

7 comments

    1. Hi Luiz, You can’t use RDS only as it doesn’t have SSRS.There are couple of options that you can try: 1. Create an EC2 instance for SSRS and set your rds instance as the database. 2. Or else you could use the Microsoft AMI which I have mentioned in my blog article as the database server or for installing SSRS and specifying RDS instance as the dbserver. Best part is if you use a seperate server for SSRS then you can increase performamce of reports generation.

      Thanks
      TechJukeBox (Sanjaya Yapa)

  1. I think this is one of the most important information for me.
    And i’m glad reading your article. But want to remark on few general things, The site style is wonderful, the articles is really great : D. Good job, cheers

  2. Hey There. I found your blog using msn. This is a very well written article.
    I will be sure to bookmark it and return to read more of your
    useful information. Thanks for the post. I will certainly comeback.

  3. I’m wondering if there are any updates to this. I’ve been tasked with getting SRSS working with AWS RDS. I have very limited experience with RDS and MS SQL coming from an Oracle environment for the last 10 years. I’m hoping this works for our needs..

    1. Still there is no direct support with RDS. But you can provision an EC2 with SQL installation and attach the RDS Database to it. You can use the EC2 to configure reporting services and use the RDS instance with that. When you are setting up the EC2, it’s better to use. Following link list the enhanced Microsoft AMIs available as of now.
      http://aws.amazon.com/windows/amis/

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s