Skip to main content

Posts

Showing posts from February, 2017

How To Connect To Amazon RDS SQL Server Database Instance Using SQL Server Management Studio

Amazon RDS is a wonderful tool for creating databases in AWS. If you use Microsoft's SQL Server Database, you might be wondering how you can manage your database while using Amazon RDS SQL Server instances. The answer is, the same way you always have - by using SQL Server Management Studio. In fact, managing your Amazon RDS SQL Server database instance using SQL Server Management Studio is SUPER easy! Let me show you how. I am going to assume that you already have SQL Server Management Studio installed on your machine and running. Open SQL Server Management Studio. Click on Connect in the upper right hand corner of the Object Explorer. Click on Database Engine. You will be presented with the following screen . If you are using Windows Authentication in Amazon RDS, then you will switch to that Authentication method. If you are not, then select SQL Server Authentication . In this case, my Amazon RDS SQL Server instance is set to use SQL Server Authentication. . Now, go ...