Ms sql express edition issue

Discussion in 'Databases' started by taarzan, Jun 18, 2010.

0
  1. #1
    I am trying to connect to remote server using MS SQL SERVER EXPRESS EDITION thing is that it throws error that cannot connect to remote server .

    My question is that does MS SQL SERVER EXPRESS EDITION support remote connections or not if YES then mention the necessary changes to be made or steps to go through. I need this matter sorted out asap.
     
    taarzan, Jun 18, 2010 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    Can you explain what is trying to connect to the database (application, management console, website), and how the servers are separated (separate networks, same network, etc..)?

    It does support connecting remotely, and is most likely as matter of configuring, and firewalls.
     
    jestep, Jun 18, 2010 IP
  3. wisdomtool

    wisdomtool Moderator Staff

    Messages:
    15,825
    Likes Received:
    1,367
    Best Answers:
    1
    Trophy Points:
    455
    #3
    Check if you have firewall blocking? If yes open a port and configure the SQL to listen to that port alone.
     
    wisdomtool, Jun 18, 2010 IP
  4. taarzan

    taarzan Active Member

    Messages:
    240
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    53
    #4
    Well I am trying to connect to online database server from desktop application to update data over there thing is it is not connecting with express edition.
     
    taarzan, Jun 18, 2010 IP
  5. asbrainztech

    asbrainztech Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    sure it support remote server......but plz check firewall and port configuration,if configured then ok ...otherwise configure it.
     
    asbrainztech, Jun 20, 2010 IP