connecting local desktop application with remote sql server database

Question

0.00/5 (No votes)

See more:

i have created one c#.net application.
in that application back-end is sql server.
when the application and database are on same machine , it works fine.
i want to know how can i connect my application with remote server database.
means the database will be in remote computer , they will connected through LAN.

if any one know how to do this, PLEASE reply.............

when i assign Data Source as server ip address it gives error....

at client side which software i have to install........please help.....
and how to allow intranet zone at client side........

Posted 19-Jul-11 20:17pm

yogesh89

Updated 20-Jul-11 1:50am

v3

Add a Solution

Comments

Toniyo Jackson 20-Jul-11 2:18am

Just change the server name to remote server ip in connection string.

4 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)

Shameel · Accepted Answer · 2011-07-19T20:22:00

Solution 1

specify your database server name and instance name in the 'Data Source' attribute of the connection string. If it is the default instance, specify the server name alone.

Posted 19-Jul-11 20:22pm

Shameel

Comments

yogesh89 20-Jul-11 7:47am

thank it works.........

Abhinav S · Accepted Answer · 2011-07-19T20:35:00

Solution 2

Have a look at http://www.carlprothman.net/Default.aspx?tabid=93#MSRemoteSQLServer[^].

Posted 19-Jul-11 20:35pm

Abhinav S

Comments

yogesh89 20-Jul-11 7:47am

thnks for help........

shefeekcm · Accepted Answer · 2011-07-20T02:05:00

Solution 3

hi,
try this,
connectionString="Data Source="ip";Initial Catalog="";User ID="";Password=""

Posted 20-Jul-11 2:05am

shefeekcm

Comments

yogesh89 20-Jul-11 8:06am

thank but now i need this...........
at client side which software i have to install........please help.....
and how to allow intranet zone at client side........

Laurence1234 · Accepted Answer · 2011-07-20T02:47:00

Possible solutions:

Check in IIS on the server that the default port is open or that you don't have to connect to a specific port? i.e. 192.168.something.something:5555 may be blocked.

Check firewall settings on server?

Check that the server is on the same sub-net within the LAN?

In the connection string set TrustedConnection to true ?

Hope that helps

connecting local desktop application with remote sql server database

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us