Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. Web Development
  3. ASP.NET
  4. connection to local sqlserver through internet

connection to local sqlserver through internet

Scheduled Pinned Locked Moved ASP.NET
databasecomsysadminwindows-admin
3 Posts 2 Posters 1 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    manish m meshram
    wrote on last edited by
    #1

    Hi, My Sqlserver in on a local windows 2003server which is connected in Lan and internet connection is through Router And i have to access its Database through internet or Remote connection. Suppose my internet provider ip address is 192.178.12.101 and My local windows server 2003 lan ip address is 192.148.1.86 So what will be my connection string Thanking You email add: manish.m.meshram@gmail.com

    C 1 Reply Last reply
    0
    • M manish m meshram

      Hi, My Sqlserver in on a local windows 2003server which is connected in Lan and internet connection is through Router And i have to access its Database through internet or Remote connection. Suppose my internet provider ip address is 192.178.12.101 and My local windows server 2003 lan ip address is 192.148.1.86 So what will be my connection string Thanking You email add: manish.m.meshram@gmail.com

      C Offline
      C Offline
      Christian Graus
      wrote on last edited by
      #2

      you need to expose your database to the internet. Then it's the IP address of your machine on the internet. The local address is worthless.

      Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

      M 1 Reply Last reply
      0
      • C Christian Graus

        you need to expose your database to the internet. Then it's the IP address of your machine on the internet. The local address is worthless.

        Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

        M Offline
        M Offline
        manish m meshram
        wrote on last edited by
        #3

        Hello I do not find any article in your blog about "connection to local sqlserver through internet" Take an example In textbox i am giving "tcp:192.168.1.81,1433" string conn = "Data Source=" + @textbox.Text + @"\CCSSQLSERVER2005;Initial Catalog=CCSHMSDNET;Integrated Security=True"; My local machine is in network, i have to access it through Router by internet email add: manish.m.meshram@gmail.com

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups