Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I want to connect to sql server from my home computer to my servers sql server.

I know people say this is a security issue, but rackspace cloud sites seems to be allowing it? :)

Anyhow, how hard is it to do?

share|improve this question

3 Answers 3

up vote 0 down vote accepted

You don't mention the SQL Server version, but here goes:

In both cases, you may need to Configure the Windows Firewall to Allow SQL Server Access

share|improve this answer

You need to have the SQL server port opened through your office firewall. The SQL port is usually 1433.

At your office firewall they need to open the port, and forward it to the IP address of your SQL server.

In your SQL connection, you then use the IP address (or the FQDN if it has one) of your office internet connection.

As for how hard this is, this depends on whether or not you have access to the firewall yourself, or if you have to convince a sysadmin to do it!

If in any doubt, please see this MS KB article.

share|improve this answer
    
actually, i'm referring to on the windows box at the ISP. be default you can't access sql server remotely. –  user2659 Dec 4 '09 at 1:36
    
Oh, well that's something completely different, and is a question that's been covered dozens of times on ServerFault. I'll find a link to one... –  Mark Henderson Dec 4 '09 at 2:49
    
Try this: serverfault.com/questions/58759/… –  Mark Henderson Dec 4 '09 at 2:51

If you open up a live chat from the link on their page (clicky) I can pretty much guarantee someone will do their best to help you. That's what they pride themselves on.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.