To connect to your MSSQL database remotely, please use a client that is capable of communicating with our MSSQL 2012 server on the TCP protocol. A free client is provided by Microsoft at: http://www.microsoft.com/downloads/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en
We recommend using Microsoft SQL Server Management Studio (link above) as many other tutorials and knowledgebase articles are written around supporting this free client by Microsoft.
How to Use Microsoft SQL Server 2008 to Connect to your Database ?
1) Open SQL Server Management Studio.
2) Set the Server type to Database Engine.
3) Enter your Server name. If you are unsure of what your server name is, you can find it under Location in your DotNetPanel.
4) Set the Authentication to SQL Server Authentication.
5) Use the User name and Password that you set up for the database in your DotNetPanel.
6) Using the Database server and the user name “Example”, the window should now look like this.
Also, Click the Options button, then the Connection Properties and make sure you type master in there (VERY IMPORTANT STEP)
7) Press “Connect” and your window should now look like this.
