How to set up server client network on different computers with the client accessing database through a cross over cable using c#

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

VS2008

, +

Hi;

Please i need help on how to set up my server and client on a separate computers and network with a cross over cable. The client must be able to access database table stored on the server computer and be able to make some changes on it. i program with c# on visual studio 2008 and sql 2005. Please you refer me to any useful materials

Thanks guys!

Posted 22-Oct-12 4:58am

Mesonrale

Updated 22-Oct-12 4:59am

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 22-Oct-12 11:43am

Why?
--SA

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)

Sushil Mate · Answer 1 · 2012-10-22T05:47:00

Beginners guide to accessing SQL Server through C#[^]

For setting up LAN in two system:
setting-up-a-simple-lan-connection-between-2-pcs/[^]
http://www.ehow.com/how_4815595_setup-lan-windows-xp.html[^]

Quote:
SQL server 2005 and 2008 provides some step by step installation process for installing the SQLserver. At the time of installing we had an option to choose for sql server agent.

here we need to select the option as "Network service". insted of local system and local service.

We can also set this option even after installation process over.

in stat menu we have allprograms tab -----> microsoft sql server -----> sql server configuration manager. In that we can see the process related to sql server,
there is process called sql server agent, right click on it and select properties tab,
In Log on tab there is radio button called as Built in account., select it and select Network service form the drop down list. then apply and restart the service again.

Now you can able to access this sql server data in Network. If you had any problems restart system try again.

This links might help you to setup SQL Server.
http://www.easyaccounts.in/lansettings.html[^]
http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-connect/4823/Failed-to-connect-to-SQL-express-on-LAN[^]

a1mimo · Answer 2 · 2012-10-22T05:49:00

Solution 3

All you need to do is to change the server section in your connection string from the local computer to the server name or IP and remember to put an exception for the sql Server port in your firewall in the server and also always run the sql Server as administrator and from the sql configuration manager make sure you allow TCP/IP and Named Pipes connections

hope this helped good luck

Posted 22-Oct-12 5:49am

a1mimo

Comments

Sushil Mate 22-Oct-12 11:52am

delete first solution :)

a1mimo 22-Oct-12 11:59am

I did sorry it didn't even tell me it posted both of them my bad
thanks :)

Sushil Mate 22-Oct-12 12:02pm

it happens.. be cautious while posting.. check twice.. refresh it once you done. so you can check its published or not :)

a1mimo 22-Oct-12 12:06pm

Sure I will :)