Search This Blog

Sunday, November 9, 2014

Connect to AWS RDS mysql remotely to VPC

There are different between connecting to MySQL (RDS) hosted in Amazon Web Services (AWS) in VPC and without VPC remotely from our computer/local.

For the RDS is not in VPC, we can add our local IP to RDS Dashboard -> Security Group.


The case is totally different if  RDS is in VPC. We are not allow to do any setting or add our local computer IP here.


In order for us to access/connect to MySQL (RDS) in AWS that is in VPC, we need to add our IP in VPC which is under EC2 Dashboard -> Security Group. Add local IP to the security group that is using the RDS. In My case is Default group.
Please follow the step by step guide in the print screen.






Hope this helps.

Saturday, November 1, 2014

SQL Server 2008 is not a valid login or you do not have permission

Facing issue when try to install Microsoft SQL Server 2008 R2 in Windows 7.

TITLE: Microsoft SQL Server 2008 R2 Setup ------------------------------ The following error has occurred: '' is not a valid login or you do not have permission. For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&

Solution:

Most of the people will face this error if the computer name and the user name is the same. Once change one of these, problem will be solved.