Post reply

connecting remote server

  • August 2, 2006 at 5:06 pm

    #169649

    Hi friends

    we've C# app that connects a sql server 2005. we've new requests from client that when users go offsite they still want use our app and connect to sql server.

    my question is how can we connect to sql server remotely ?

    is it using TCP/IP protocol ? if so how do we do that ?

    Thanks for ur help.

  • August 3, 2006 at 5:17 am

    #653036

    do they have a vpn? do they have any way to connect to their network when their off site?

    if so, once their connected it should work fine...

    you may need to add the IP Address of the server into the hosts file but if everything is working right this is not needed

  • August 3, 2006 at 2:43 pm

    #653212

     
    >>do they have a vpn?
    probably we can arrange one.
     
    >>do they have any way to connect to their network when their off site?
    i thought being on internet would be sufficient. so they need to dial in to their network first using VPN then use our app ?
    i thought we could do something like websites do .i mean like using windows app we could connect to a remote server and thought as long as they've internet connection that would be sufficient.
     
    Thanks

  • August 3, 2006 at 2:53 pm

    #653216

    it would be more secure within the vpn

    using a remote server through a website is fine to, just creates an extra layer to manage and keep secure.

    We use a website to make calls to our internal sql server. It is set up to only have permission to execute certain stored procedures. We dont allow any free form sql to be passed or executed from the web site and that works pretty well.

    technically, your right, if you connected to the net, you can access things. but that also requires configuring the machine to allow access to the outside world through some kind of service.

    seems to me i remember the makes of pc anywhere comming out with a product called sql anywhere. that might be a solution. so would pc anywhere, carbo copy, vnc... these all allow you to connect to another machine and operate them like yours standing there.

  • August 3, 2006 at 2:56 pm

    #653218

    Thanks Claude
    you gave me a start.will investigate more on those lines.
     

Viewing 5 posts - 1 through 4 (of 4 total)

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