This guide shows how to connect to an MSSQL (Microsoft SQL Server) database that you have created with Loopia, using SQL Server Management Studio. The steps cover where to find your database details in the Customer Zone and how to enter them in the client.
We recommend that you download Microsoft Management Studio to manage your databases.
Find your MSSQL details in the Customer Zone
Start by logging in to the Loopia Customer Zone and go to Account settings -> MSSQL information.
Here you must note the database name and server. You can then create a user at the bottom of the page.
Connect with SQL Server Management Studio
Start SQL Server Management Studio and fill in the server name, login and password with the information from the Customer Zone, where server name equals server.
Then click Options and go to the Connection Properties tab.
Here you must fill in Connect to database and tick Encrypt connection. Next to Connect to database, choose the name of your database.
You should now be able to connect to your MSSQL (SQL Server) databases by clicking Connect at the bottom of the page.