In this post I am will demonstrate how to connect to UAT database (Azure) in SQL server management studio unlike DEV environment where database sits on same box.
Following are the steps involved in connecting SQL server management studio to UAT database:
Step 1:
Go to your environment page in LCS and scroll down to database accounts sections under Manage Environment tab.
Step 2:
Open SQL Server Management Studio in UAT environment and put the highlighted SQLServer\Databasename in Server name box with addition to ".database.windows.net" as shown below
Step 3:
Set the Authentication mode to SQL Server Authentication, get the password from environment page under database accounts section and hit Connect.
You are now connected to UAT database.
