Post reply

Sql Server Access across remote machine

  • July 24, 2006 at 1:48 am

    #92139

    I was just trying out Microsoft SQL Server 2000. I created a sample application which reads in 2 values from a textbox and writes it into a databse. This application works fine on my computer and the values are written to the database (In the connection string, I give my IP address as the datasource so that anyone on the internet can hit this database). However, when I copy this application to another computer and try to run it, it gives me an error "SQL Server does not exist or access is denied." I know this is a minor problem with some setting, but I haven't been able to find the solution on the internet. Can someone whose worked with Microsoft SQL Server 2000 please help me out.

  • July 24, 2006 at 9:00 pm

    #651235

    you have to open a port in your firewall to allow your sql server to be visible to an outside IP address; further, if you are going to do this, you know all about the caveats about making sure it's patched and as hardened against attack as possible;

    open an external port that is way way different than the normal port, and use network address translation to map the port to the internal ip address;

    ie use port 22222 and map it to the port your server is listening on;

    then in the application have it connect to  the server http://www.yourwebsite.com,22222 (note the comma); the connection string will then use that port instead of the default.

    HTH

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply