How do you use SQL Server from another PC on the same network?

Question

0.00/5 (No votes)

See more:

I have a home network with two PCs connected. The one pc has SQL Server installed and also an Excel spreadsheet that reads data from a database table in SQL server. The excel spreadsheet is in a shared folder so the other PC can open and edit the file, but can not refresh the data retrieved from the sql server database table. I keep getting an error message that says the server does not exist. And i can't login as a guest.

Is there anyway i can use the excel file on the network and refresh the data from the sql server from any pc on the network?

Posted 17-Nov-13 6:05am

Member 10407177

Add a Solution

Comments

RedDk 17-Nov-13 13:47pm

Just off the top of my head I'd say the first thing to do is install the same version of SQL Server that is used on the target machine on the machine on which you're running this Excel spreadsheet.

The tribulations of connection are going to be compounded by a number of next first steps.

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)

Mehdi Gholam · Answer 1 · 2013-11-17T08:07:00

Solution 1

1) Enable networking on your SQL Server (default is off) see : http://technet.microsoft.com/en-us/library/hh231672.aspx[^]

2) Configure the firewall on your SQL Server machine to allow SQL Server

3) On a home network connect via IP address instead of names (type IPCONFIG in your run to see what your SQL server IP is - usually like 192.168.x.x ).

Posted 17-Nov-13 8:07am

Mehdi Gholam

Comments

abbaspirmoradi 17-Nov-13 14:26pm

+5

Mehdi Gholam 18-Nov-13 1:47am

Thanks!

Maciej Los 17-Nov-13 18:17pm

I would like to say: the shortest tutorial i've ever seen ;)
+5!

Mehdi Gholam 18-Nov-13 1:48am

Hopefully I didn't miss anything! :)

Maciej Los 18-Nov-13 9:03am

;)

Kannannns · Answer 2 · 2013-11-17T20:13:00

Solution 2

go to http://csharp-sqlconnection.blogspot.com/[^] for easy and shortest way for database connectivity

Posted 17-Nov-13 20:13pm

Kannannns

Updated 18-Nov-13 5:21am

v2