How to connect sql server database over the WAN

Question

1.00/5 (2 votes)

See more:

SQL-Server-2005

, +

I want to access sql server database over the WAN.I got little idea that we can use Named pipe for this but I am not sure.
If its possible then what settings I should do in my firewall.

please suggest..

thanx.

Posted 9-Aug-12 22:00pm

Anupam Singh

Add a Solution

Comments

[no name] 10-Aug-12 7:15am

Read the documentation for whatever firewall you have. How are we supposed to know how you network is configured?

2 solutions

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)

Manfred Rudolf Bihy · Accepted Answer · 2012-08-09T22:15:00

Solution 2

If you will be communicating over a WAN with your SQL server, please use TCP\IP as named pipes are only of use in a local subnet. You'll have to enable that on your SQL Server 2005/2008 installation. In order for the SQL clients to connect, you'll have to open up the port 1433 (standard SQL Server port for TCP/IP) for inbound traffic on the side hosting the SQL server. The client's side will have to have port 1433 opened up for outbound traffic.

Hope that helps!

Regards,

Manfred

Posted 9-Aug-12 22:15pm

Manfred Rudolf Bihy

Updated 9-Aug-12 22:17pm

v2

Comments

[no name] 10-Aug-12 4:18am

Actually dear , I am accessing this DB in LAN using TCP\IP ,at 1433.Its working fine..

Manfred Rudolf Bihy 10-Aug-12 4:38am

So why did you write that you want to access the SQL Server over a WAN connection? You should take more care to formulate yor questions better and if "it's working fine", where is your problem? Your are not being clear.
Sorry!

Wendelius 10-Aug-12 16:55pm

Fair answer, 5

Charles Shob · Accepted Answer · 2012-08-09T22:09:00

Solution 1

Are you mentioning about Windows forms???

If so, use public IP on SQL server machine while opening the used ports of TCP/IP or named pipes you are using and enable remote access of sql server. It does not matter actually wheather you are trying to access thru web module or Wind forms app. But performence actually matters.

Posted 9-Aug-12 22:09pm

Charles Shob

Comments

[no name] 10-Aug-12 4:13am

Actually I have access DB using SSMS.and database is not in public IP.So I have to configure firewall as well sql browser and remote access are already enabled..