How to make SQL Server visible on internet?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

This is embarrassing for me, but I have no idea what to do.
I want to connect to SQL server from my home and field office; what else should I tweak?
I could use VPN (it works), but I prefer to connect directly.

My admin is on vacation and I'm starting to appreciate his work even more.

Facts:
SQL Server 2008 R2:
All services are running
Mixed authentication is enabled
TCP/IP protocol is enabled

OS:
Windows Server 2003 SP2

Please help.

P.S. I've restarted my machine after applying changes.

Edit: sysadmin returned and it looks like we are having major problem concerning our network.

And important note for those who aren't aware of risks of exposing sql server to the web:
This is generally very bad idea!
Use VPN if possible or web services for specific tasks or DirectAccess.

Posted 29-Aug-11 2:33am

Oshtri Deka

Updated 30-Aug-11 1:29am

v4

Add a Solution

Comments

[no name] 29-Aug-11 8:35am

Are you getting any error while trying to connect?

Oshtri Deka 29-Aug-11 8:51am

Yes, but at the moment I cannot reproduce it nor copy it =/ (I'm away from my "remote" machines).
As I recall, Server cannot be found.
IP is static, and I can connect with same connection string within any computer within domain.

Oshtri Deka 29-Aug-11 10:38am

I receive following link in my error message:
http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

#realJSOP · Accepted Answer · 2011-08-29T02:54:00

Solution 2

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277[^]

Posted 29-Aug-11 2:54am

#realJSOP

Comments

Oshtri Deka 29-Aug-11 9:39am

I've done all that is mentioned on support site; all beside firewall expection for sqlBrowser. I'll will try to connect later (remote machines are down).

It looks like I always ask wrong questions in search machines... I should have found link you have provided by myself.

Oshtri Deka 29-Aug-11 10:48am

I still cannot connect. This is the link I get with error message:
http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1

I believe I've done everything from support page and everything mentioned from in help page.
Do you have any ideas?

Oshtri Deka 30-Aug-11 7:28am

@John: I'll wait to see how will things turn out before I accept solution.
My 5.