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
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Connecting remote SQL server

Connecting remote SQL server

Scheduled Pinned Locked Moved Database
securitydatabasesql-serversysadminhelp
3 Posts 2 Posters 0 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.
  • Y Offline
    Y Offline
    Yaakov Davis
    wrote on last edited by
    #1

    Hi. I'm trying to connect to a remote SQL serer express through TCP/IP. I entered the in the server name field. I tried also without the instance name. I tried with integrated security as well as authentication. Also, I tried with the port address, and I get the error message "TCP Provider: Connection closed forcibly by the remote computer". P.S. the protocol is enabled on noth the local and remote sides. Can anyone explain me please how to establish a connection? Thanks, Yaakov

    C 1 Reply Last reply
    0
    • Y Yaakov Davis

      Hi. I'm trying to connect to a remote SQL serer express through TCP/IP. I entered the in the server name field. I tried also without the instance name. I tried with integrated security as well as authentication. Also, I tried with the port address, and I get the error message "TCP Provider: Connection closed forcibly by the remote computer". P.S. the protocol is enabled on noth the local and remote sides. Can anyone explain me please how to establish a connection? Thanks, Yaakov

      C Offline
      C Offline
      Colin Angus Mackay
      wrote on last edited by
      #2

      Given the error message you got it might be a better idea to look on the server to see what the problem is. However, if the problem is with your code then we cannot help you unless you post the code you are using.


      My: Blog | Photos WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

      Y 1 Reply Last reply
      0
      • C Colin Angus Mackay

        Given the error message you got it might be a better idea to look on the server to see what the problem is. However, if the problem is with your code then we cannot help you unless you post the code you are using.


        My: Blog | Photos WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

        Y Offline
        Y Offline
        Yaakov Davis
        wrote on last edited by
        #3

        I'm trying to connect from the VS IDE. I own both the server and the client, and I see no problem on both. Can you reffer me to a relevant artical? Thanks, Yaakov

        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