Managing Your aspnetcore.net Database with Microsoft SQL Server Management Studio (SSMS)
In the previous section, we have successfully installed the Microsoft SQL Server Management Studio. In this section we will go through the steps of connecting to your aspnetcore.net database from SSMS, using your Username and Password.
Once logged in, click on the “Manage Databases” link on the left sidebar of your dashboard. Your databases should display on the screen (if the list is empty, then you need to create a database. Please refer to the Getting Started guide for detailed instructions).
You may now proceed to the next step and click the “My Files” link on the left sidebar.
Now you should be on the file browser module, which allows you to upload, download and manage your files on the server. By default, the files manager displays the list of files and folders on your account.
Scroll down the list of files. We are looking for the file called “web.config”. Once you find it, click the edit icon that should be displayed on its right.
The edit icons opens up the “web.config” file in the online file editor. The “web.config” files is nothing but a simple xml file. We will use this file to retrieve authentication credentials (Username and Password) of our demo / sample database.
As you can see in the following screen, the Username in this case is: demo_SampleDB, and the Password is: DBSamplePW.
Now head back to Microsoft SQL Server Management Studio (refer to the previous section for detailed steps of how to install and launch SSMS).
You need three pieces of information in order to log into a database server: The server name, the username and the password. Use the following as Server name: sql.freeasphost.net\MSSQL2016
Next, select “SQL Server Authentication” for the Authentication field.
Now, you can use your database credentials (Username & Password) from Step 5, and press “enter” or click “Connect”
If everything goes well, you should now be logged in. The sidebar of SSMS displays folders and objects from the database server. If you open the “Databases” folder (by clicking on the small + “plus” sign), you will see the list of databases, and hopefully our “demo_SampleDB” schema.
You may open it (by clicking on the small + “plus” sign), and it should display the content of our demo schema (Tables, Views, etc).