Connect to SQL server from another PC on same network

Question

0.00/5 (No votes)

See more:

Hi, I am tired to search my problem.
Can someone help me.

For example, I have master app on Pc with SQL server 2005

How I can connect to master app from another Pc, if both computers are in same network?
I need just to read from Data Base and write some data back in Data Base.

Thanks, and sorry for my English if there is some funny grammar errors ;)

Posted 30-Aug-10 11:38am

valza

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)

Christian Graus · Answer 1 · 2010-08-30T11:47:00

Solution 1

You just need a connection string that specifies the network path to the machine and the database on the machine.

Posted 30-Aug-10 11:47am

Christian Graus

Per Söderlund · Answer 2 · 2010-08-30T19:16:00

With a connection string you connect to the database directly and not through another application.
It is possible to set this up with Visual studio on the data menu,click add new data.If sql is configured it should be on the list after you click new connection.Not sure how this works in express versions though.