To connect to your database through Microsoft SQL Server Management Studio, you have 2 Authentication choices. Windows Authentication and SQL Server Authentication.
If you are connecting to your database from a remote location, such as your Home or Office, you are going to want to use SQL Server Authentication. This method allows you to enter the Database Server location (Such as the Server Name or IP Address) and a Database Username and Password in which to authenticate with. Once logged in, you will only have access to the databases that the Database Username has permissions for.
In order to connect using SQL Server Authentication, you will need the IP address or Server Name, and the Database Username/Password login information. If you do not have this information, create a support ticket and we will assist you in locating the correct information. Otherwise, if you need to create a user for the first time, you can add a new user through the Database Manager section in your HELM Control Panel.
If you are having trouble connecting to your Database Server from a Remote location, be sure to check the Server’s Firewall to ensure that the proper SQL Port (1433 unless otherwise specified) are open. If your SQL Server is listening on a different port other than 1433, you will need to specify the port in the Server Name field after a comma (eg: SERVER_IP,SERVER_PORT).
An alternative to SQL Server Authentication, is Windows Authentication. This is useful if you are logged directly into your Database Server through Remote Desktop. Once you open Microsoft SQL Server Management Studio on the remote server, select “Windows Authentication” for the Authentication type. This will connect you to the database server using the Username you are currently logged into the Remote Server with. If you are logged into the Remote Server as an Administrator, then you will have full Administrator access to all the databases on the server.
If you have any questions or run into any problems, feel free to create a Technical Support ticket and we will be happy to assist you!