How to set up web-based SQL server on OpenStack instance using SQL image?

Pre-requisites:

  • SQL Window server

  • Window console

  • Good internet connection

Follow the below steps:

Step 1: Go to Run and type mstsc and hit OK.

Step 2: Enter your IP address and select Show Options.

Step 3: Enter Administrator in the username and hit Connect.

Step 4: Enter the password field and hit OK.

Step 5: Click Yes on the certificate prompt.

Step 6: Go to the Start button and select Microsoft Server Tools.

Step 7: Select SQL Server Management Studio.

Step 8: Select SQL Server Authentication as the Authentication type, enter SQL in Login, Admin@321 in the password for SQL Server, and hit Connect.

You are now logged into the server.

You can also change your password. Follow the below steps:

Step 1: Select Security, then choose Logins and select SQL.

Step 2: Enter the password, confirm the password and old password, and hit OK.

Your password has now been changed successfully. Enter your new password to log in again.

Last updated