Start QA VM: Difference between revisions

From Bitnami MediaWiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 15: Line 15:
<strong>3.</strong> If the virtual machines icon is not showing in the list of Azure services press the “More Services” link at the very right of the list. You will find virtual machines there.
<strong>3.</strong> If the virtual machines icon is not showing in the list of Azure services press the “More Services” link at the very right of the list. You will find virtual machines there.


<strong>4.</strong> From the colour selection window select the appropriate colour for the connection. Suggested colours: connection to development server = green. Connection to test server = yellow. Connection to production server = red. Press the OK button.
[[Image:Azure portal.png]]


<strong>5.</strong> After selecting the colour for the connection the Edit Server Registration Properties window will show the selected colour. Press the Save button.
<strong>4.</strong> You should now see a similar list of VMs. The QA server sqlqa01 should be in the list. Click on sqlqa01.


<strong>6.</strong> From the Registered Servers list double click the server with the recently assigned colour. A connection to that server is made and the Object Explorer is presented.
[[Image:Virtual machine list.png]]


<strong>7.</strong> From Object Explorer list of databases, right mouse click over a database and select New Query from the popup menu.
<strong>5.</strong> From the sqlqa01 page you will see buttons at the top of the right pane. The Start button will not be greyed out. In the screenshot below the Start button is greyed out because the VM has already been started.


<strong>8.</strong> Once the New Query window opens you will see the colour of the information bar at the bottom of the window is now the colour previously selected.
[[Image:sqlqa01.png]]


[[Image:Colour coded connection.png]]
<strong>6.</strong> After you press the Start button you should see an indication the VM is starting. There first will be a small popup in the top right corner saying, “Starting virtual machine”. That will disappear shortly and then the message indicator in the top right corner (bell) will have a blue line running under it. The blue line will continue its animation until the server has completed the startup.
 
[[Image:starting virtual machine 1.png]]  [[Image:starting virtual machine 2.png]]
 
<strong>7.</strong> Once the VM has completed the startup process and is now ready for use you will see a small popup in the top right corner with a green check mark and the message “Started virtual machine”. QA is now fully started and ready.
 
[[Image:started virtual machine.png]]

Revision as of 20:08, 20 September 2023


Objective: Allow a team member to restart QA after it has been shutdown for the night.

Reason for lesson: The QA VM is shutdown every evening at 7. It needs to be turned back on in the morning.

Navigate: Main Menu | Azure services | Virtual machines | sqlqa01 | Start

Steps to start QA (SQLQA01):

1. Open a web browser and navigate to https://portal.azure.com/#home

2. From the home page find the icon for Virtual Machines.

3. If the virtual machines icon is not showing in the list of Azure services press the “More Services” link at the very right of the list. You will find virtual machines there.

Azure portal.png

4. You should now see a similar list of VMs. The QA server sqlqa01 should be in the list. Click on sqlqa01.

Virtual machine list.png

5. From the sqlqa01 page you will see buttons at the top of the right pane. The Start button will not be greyed out. In the screenshot below the Start button is greyed out because the VM has already been started.

Sqlqa01.png

6. After you press the Start button you should see an indication the VM is starting. There first will be a small popup in the top right corner saying, “Starting virtual machine”. That will disappear shortly and then the message indicator in the top right corner (bell) will have a blue line running under it. The blue line will continue its animation until the server has completed the startup.

Starting virtual machine 1.png Starting virtual machine 2.png

7. Once the VM has completed the startup process and is now ready for use you will see a small popup in the top right corner with a green check mark and the message “Started virtual machine”. QA is now fully started and ready.

Started virtual machine.png