Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2003
    Posts
    7

    Unanswered: connecting MSSQl Server in local IP

    Hi

    We are hosting a Database Server for our client server desktop application

    The Database server(Microsoft SQL Server 2000) is in the internet with a Public IP as of now

    Now we have planned to bring our SQL Server to Local IP i.e. behind firewall for security reasons

    How this can be done? What should I do?

    What are all the Possiblity solution?

    What is the server name or IP should i give when a when my client application connects to the Database server.
    How the connection can be established

    anyone kindly tell me the possible methods so that my clients must be able to access the database server which is in local IP

    Thanks and regards
    Sabeer

  2. #2
    Join Date
    Jun 2003
    Location
    cape town, south africa
    Posts
    102
    in "server network utility" enable Named Pipes protocol...you should be able it access it from your local network, or application using the database server name
    (find this by running select @@servername on the server)
    If you want it to still be accesible on the outside, leave TCP/IP enabled with ext ip in properties

  3. #3
    Join Date
    Aug 2003
    Posts
    7

    connecting MSSQl Server in local IP

    yes I understand

    The Thing is My SQL Server is hosted by our Service Provider
    Now What should I ask My Service Provider to do to bring it to local IP
    as so far I was using Public IP.
    So what should be done
    So that my client application is able to to access the database server which is in Local network in the service Provider
    Can you guide me further

    Regards
    Sabeer

  4. #4
    Join Date
    Jun 2003
    Location
    cape town, south africa
    Posts
    102
    you need to ask your provider to set up a NAT (network address translation) for you. basically you will be asking them to forward any requests made on a certain port (1433 for sql default) on the external IP to the relevant port on your internal IP ...
    client apps will still use external IP for connections...
    cheers
    des

  5. #5
    Join Date
    Aug 2003
    Posts
    7
    Hi

    Thanks

    I shall try it out with my Service Provider


    Regards
    Sabeer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •