If I create an instance with a One-click application and select MSSQL, will I access it through the MSSQL connection, or can I remote into the server?

Once a Cloud instance is provisioned with a One-click application, you can either SSH directly to the server (default SSH port: 22) or use remote SQL connect (default SQL port: 3306). Please note that you need to open the security group to allow port access if you intend to SSH into the server.