HI guys
I am just started learning SQL server. I have installed sql server 2008 in one laptop (call it 1) and it is connected to internet now

  1. i want to access it from another pc which is connected with 1 via WAN.
  2. and how to connect to sql server on 1 by internet

Please help me out
Thanks

Recommended Answers

All 6 Replies

For connection string information, see http://www.connectionstrings.com. For further support on exposing your server to the internet, see the documentation or MS for further info.

Good Luck

you need to install sql server client in the other system and connect to the server to access the database..

yes I have it in the server as well as client when i try to access databases on 1 it gives an message about some connectivity problems.

Could a firewall on the server be blocking the client from accessing the SQL Server?

Sounds like a networking issue rather than a SQL server issue. I could be wrong though :)

I searched over few places and it seems that sql server needs some two or there ports .... things like that and i also thought it is something related to security so i left it.

You can use the following link to troubleshoot any connection errors. You will be surprised to know that there is tons of errors, and this covers most of them with some useful links to more. -

http://http://blogs.msdn.com/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues.aspx

Hope this helps solving your problem. It took me 3 weeks to sort mine a while ago, only to find out that my errors was system orientated and not sql server....

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.