Connecting the Windows application with SQL Server via proxy connection

Question

0.00/5 (No votes)

See more:

Hi,

I am a software developer in .Net C# 2010 RC & SQL Server 2005.

Currently developing a Windows Application Software in which the database is located in Web Server.

Software has to be implemented in stores and office, where as office is connected via LAN -> proxy server and stores are connected via Direct connection.

Myself connecting to the server via SQLClient in which I use IP Address of the server in the connection string.

When implemented in stores(direct connection) it works fine.

But when tried to connect the software to database in office(via Proxy), it generates error
"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)"

Please help me to sort out this issue.

Moreover this is my first windows application, I am basically Web developer, I am novice in network related system programming.

I had referred multiple websites, there are some programs, which have bugs or unable to implement.

Regards

Kuthubus Saman

Hi,

thanks for your reply.

But SQL Server is allowing remote connections viz., when connecting from a installation location to remote server via Direct DSL or dial up connection, it executes finely.

Problem or Error occurs when trying to retrieve data from SQL Server through Proxy connection only.

Posted 16-Mar-10 8:40am

kuthubussaman

Updated 16-Mar-10 9:33am

v2

Add a Solution

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)

Sandeep Mewara · Answer 1 · 2010-03-16T09:24:00

Error looks like a Surface Area Configuration issue.
Remote connections are currently disabled on the database server. Enable it.

1. Open this: Start->All Programs->MS SQL Server 2005-> Configuration Tools -> SQL Server Surface Area Configuration
2. Choose Surface Area configuration for Services and Connections
3. Select MSSQLServer->Database Engines->Remote Connections
4. Now select radio button: Local and Remote Connections
5. Also select using both TCP/IP and named pipes
6. Select Ok button. You can restart the SQL Service if needed.

abbasmir85 · Answer 2 · 2010-04-09T02:52:00

hello Kuthubus Saman, i didnt know how to contact you via email or anything so i replied just to talk to you, i am also making an application which needs to store information onto a server, its a voting system but not in ASP or anything, its a desktop application, can you please help me make this connection, like using internet and storing the votes from one computer onto another computer, i will be sooooooo grateful you cannot even begin to imagine. Thank You in advance please do reply

Connecting the Windows application with SQL Server via proxy connection

2 solutions

Solution 1

Solution 3

Add your solution here

Preview 0