Microsoft SQL Databases (Foundation)

What is Microsoft SQL

Microsoft SQL is an open-source database management system that uses Structured Query Language (SQL), a widely used language for adding, accessing, and processing data in a database. Microsoft SQL is the most commonly used Web application alternative to proprietary database systems because of its speed and reliability. Microsoft SQL can run on UNIX, Windows, and Macintosh operating systems.

How to Connect to a Microsoft SQL Database

1. Log in to Foundation and go to the Hosting tab.
   
   
   
   
2. Look for the Microsoft SQL option from the side menu.
   
   
   
   
3. Find the database that you wish to set up the connection for and click on Manage.
   
   
   
   
4. On the far right side of the Database user section, click on Add New User.
   
   
   
   
5. Enter the details (username, password, and confirm password) for a particular database and click on the Add User button.
   
   
   
   
6. You will get a message, and the details will be stored under Database Users.
   
   
   
   
7. On the far right side of the Database user, click on the vertical ellipsis.
   
   
   
   
8. When you click on the vertical ellipsis, two options will show.
   
   
   
   
   • Change Password
   • Delete User

Change Password

1. Click on Change Password to update the password.
2. Enter and confirm the new password, and then click the Update User button.
   
   
   
   
3. The password will be changed, and a message will be displayed confirming the update.
   
   

Delete User

1. If you want to delete the user, click on Delete User.
   
   
   
   
2. When you click the Delete User option, a modal window will appear.
   
   
   
   
3. Click the Delete User button, and it will delete that user and display a message.