[Last Call] Learn how to a build a cloud-first strategyRegister Now


Connecting to Microsoft SQL Server

Posted on 2009-12-30
Medium Priority
Last Modified: 2012-05-08
I've been a user of MySQL and have used the tools that come with it to more easily connect to it and work with it... I recently bought some service through Gate.com and it comes with MS SQL Server. How do I connect to it... is there a client I can use? I downloaded the MS SQL Server Management Studio Express software but I can't connect with it.
Question by:dajwilso
LVL 26

Expert Comment

ID: 26145651
do you connect to  the server with a sql account or domain account? can you ping the server?
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 26146029
You have to contact the support persons in gate.com, some of the providers will allow the users to connect to the sql server only thru some " remote admin" consoles

Accepted Solution

dajwilso earned 0 total points
ID: 26146663
It was just the hostname. They gave me the wrong one! I was able to connect with the sql server management studio express.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Integration Management Part 2
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question