Knowledgebase: MSSQL
How can I connect to my MSSQL database remotely?
Posted by Arvand Sabetian (Import) on 20 July 2009 04:52 AM
To connect to your MSSQL database remotely, please use a client that is capable of communicating with our MSSQL 2008 server on the TCP protocol. A free client is provided by Microsoft at:

We recommend using Microsoft SQL Server 2008 Management Studio (link above) as many other tutorials and knowledgebase articles are written around supporting this free client by Microsoft. Only the 2008 version will be able to connect to our MSSQL servers. If you have the 2005 version, please upgrade. The 2008 client is backwards compatible with 2005 servers so you will still be able to connect to your MSSQL 2005 servers with the 2008 version.
(180 vote(s))
Not helpful

Comments (16)
Lance Baatz
22 March 2010 10:24 PM
I was looking for connection information - as in once I have SSMS installed, how do I connect to my db!

RESPONSE: Your database username and passoword are chosen inside your control panel by yourself. The hostname for the db server is your domain name (if it is propagating) or the server name ( where server_name is the server name outlined in your setup email.
29 May 2012 07:56 PM
Is it possible to use Microsoft SQL Server 2012 Management Studio?
Michael Carr
27 September 2012 10:15 AM
Yes, version 2012 should be able to connect 2008 SQL server.
Irfan Bhatti
10 July 2012 06:28 AM
I know this has probably been resolved already but I thought I would post it just in case someone else who is new like me also wants quick info about remotely connecting. My first obstacle was finding out my server name but thanks to the above response, I found it.

I checked the email I received from arvixe which had "Hosting Account Information" as part of the email subject. In there, there is a section called "Connecting to SQL Server and MySQL Server (Advanced)". In that section, it gives you the name of the server. You enter this in management studio. Then for authentication, you choose "SQL Server Authentication" not "Windows Authentication". Then I entered the same username and password I used when I created the database through the control panel. This allowed me to connect without a problem. Hope this helps. Take care
Edvard Hojnik
26 September 2012 02:56 AM
I have successfully connected to database with miscrosoft sql server 2008 management studio. How can I set permissions for users that I have created inside my control panel, because by default user just have public permissions, but I want to set him an sysadmin privilages... I don`t see that option in control panel and I don`t have permission with newly created user to grant him some privilages ...
For sa user that is default when I create new database in control panel I don`t get password...

Thanks for your help
Michael Carr
27 September 2012 10:07 AM
The permissions are set through the control panel. Your database users can have read or write access to specific tables, or global access to alter anything within the entire database. Creating a database does not assign any users to it, after you create the database you then assign a user and set that users permissions.
15 January 2014 06:55 AM
Pls could you guide me on how to access my sql server database directly via management studio
I need to interact with it manually.
I actually uploaded my database via backup file from plex panel

Pls help

Thanks a million
Happy new year
Michael Carr
16 January 2014 10:40 AM
Try using this guide :
30 March 2014 04:59 AM

I can connect to my database with sql management studio without a problem, but I just think it's weird how I keep seeing a bunch of other databases that aren't mine when I browse through the object explorer.

It's also a pain since I have to scroll all the way down to find my database between all those other databases.

Is there a way to hide the databases that aren't mine?

Thanks in advance
Michael Carr
16 April 2014 09:02 AM
This is the default behavior of MSSQL. You will be able to see the other databases on the SQL server but not access any of them. I am not aware of a method to hide the other databases
Min Soe
30 March 2014 07:46 PM
I'm having following error when I try to connect.

Cannot connect to


A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)

For help, click:

Error Number: 53
Severity: 20
State: 0

Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean withFailover)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject, Boolean withFailover)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Please help me.
Michael Carr
16 April 2014 08:57 AM
This is likely an issue with your connection string. Please open a support ticket and we will be happy to investigate further for you.
ajay gupta
08 June 2014 11:06 AM
I am using a apache build xampp server and using it i am getting an error
"The server requested authentication method unknown to the client"
Is it possible to solve it by using xampp
Michael Carr
20 June 2014 10:20 AM
Please open a support ticket and we will be happy to investigate for you.
John Olson
12 August 2014 09:41 AM
If I do not have the DB setup email, where can I find the server name for SSMS?
Michael Carr
09 September 2014 07:43 AM
The server name is listed in your welcome email when the account was first setup. If you are unsure you can contact support and we will be happy to look it up for you.
Post a new comment
Full Name:
CAPTCHA Verification 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).