Sunday, 1 March 2015

Connect to the SQL instance hosted on cloud (Azure and AWS)

Below table will give you an perfect example on how to connect SQL instances like Database and Analyasis service hosted on cloud

Connection Scenarios : SQL on AWS
Connection Type
Prerequisite/Requirement
Connection using Client SSMS
Recommendations

@ AWS Management Console
@ VM Level
Authentication @ VM Level
Authentication @ Client machine


Database Engine
Open TCP Port: 1433 at the Security group of the AWS instance


Open TCP Port 1433 at Windows Firewall
1)     Create a Windows Local User (For e.g. MAQUSer)
2)     Create a SQL Windows Login using that account
3)     Provide appropriate rights to the Windows User
Create a Windows Local user as created at SQL VM (For e.g. MAQUSer)
Open SSMS using newly created Windows Local user (For e.g. MAQUSer)


Do not use SQL Authentication for connection.
Analysis Service
Open TCP Port: 2383 at the Security group of the AWS instance


Open TCP Port 2383 at Windows Firewall
1)     Create a Windows Local User (For e.g. MAQUSer)
2)     Create a SQL Windows Login using that account
3)     Provide appropriate rights to the Windows User
Create a Windows Local user as created at SQL VM (For e.g. MAQUSer)
Open SSMS using newly created Windows Local user (For e.g. MAQUSer)


SQL Authentication is not supported for Analysis service
Connection Scenarios : SQL on Azure
Connection Type
Prerequisite/Requirement
Connection using Client SSMS
Recommendations

@ Azure Portal
@ VM Level
Authentication @ VM Level
Authentication @ Client machine


Database Engine
Open TCP Port: 1433

Open TCP Port 1433 at Windows Firewall
1)     Create a Windows Local User (For e.g. MAQUSer)
2)     Create a SQL Windows Login using that account
3)     Provide appropriate rights to the Windows User
Create a Windows Local user as created at SQL VM (For e.g. MAQUSer)
Open SSMS using newly created Windows Local user (For e.g. MAQUSer)


Do not use SQL Authentication for connection.
Analysis Service
Open TCP Port: 2383


Open TCP Port 2383 at Windows Firewall
1)     Create a Windows Local User (For e.g. MAQUSer)
2)     Create a SQL Windows Login using that account
3)     Provide appropriate rights to the Windows User
Create a Windows Local user as created at SQL VM (For e.g. MAQUSer)
Open SSMS using newly created Windows Local user (For e.g. MAQUSer) 


SQL Authentication is not supported for Analysis service

No comments:

Post a Comment