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 (server_name.arvixe.com) where server_name is the server name outlined in your setup email.

Is it possible to use Microsoft SQL Server 2012 Management Studio?

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

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

Hi,
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

Hi,

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

I'm having following error when I try to connect.
===================================

Cannot connect to atwmm.com.

===================================

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: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476

------------------------------
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.

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

If I do not have the DB setup email, where can I find the server name for SSMS?